Data Entry in a cell still in progress - how to detect and correct

P

Paul Willman

I'm not sure what the condition is called, but Excel seems to react very poorly to VB/VBA code running while a user is still entering data into a cell. You notice this situation when you are typing data in a cell and all of the command buttons become grayed out.

1) Does this situation/condition have a name?
2) How can you detect it from VB 6?
3) How can you correct it from VB 6?

Thanks,

Paul Willman
 
Top