Data entry - Command button conflict

  • Thread starter Thread starter gord
  • Start date Start date
G

gord

As an exercise, I have a bunch of cells and a command button to perform a
calculation on them. The user enters data in the cells and when ready clicks
the button. This works as expected. However, if the button is clicked while
the active cell is having data entered (i.e the user has typed something but
not yet tabbed out of the cell) then the program hangs.
Is there a method that can detect that the data entry has not been completed
to avoid this situation?
Gord.
 
Gord,

Are you sure the program hangs? It would seem to me that as input is not
complete and the cell is still being edited, then clicking the button has no
effect.

What effect do you see that leads you to believe the program hangs?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Geez Bob, You are absolutely correct. I just looked at the behaviour again
and clicking the button has no effect while the data is pending. I could
have sworn that that the program locked up but I was quite wrong!
Gord
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
How to use multiple command button to copy user form data to multiple worksheet 0
Putting 2 command buttons into 1 cell 2
Create a yes no message on a command button on click 0
Ignoring Blank cells 9
Hide Rows and Columns based on Date Input 6
Excel excel code to change command button caption 1
Data validation error with multiple CPU 1

Back
Top