ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Data Entry in a cell still in progress - how to detect and correct (https://www.excelbanter.com/excel-programming/302836-data-entry-cell-still-progress-how-detect-correct.html)

Paul Willman

Data Entry in a cell still in progress - how to detect and correct
 
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



All times are GMT +1. The time now is 06:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com