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
 
Back
Top