Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting Cell Edit Mode
I have a COM module that fires events at an Excel VBA class, the event need
to update a worksheet, but when the user is editing a cell the update fails with Application Error. Is there any way to detect wether a user is editing a cell (without trying to update one) and Cancel the users edit (maybe prompt first) so the update can go ahead? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting Cell Edit Mode
Marc
There is no good way, but this is the best that I've seen http://www.google.com/groups?threadm...0a% 40phx.gbl -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Marc" wrote in message ... I have a COM module that fires events at an Excel VBA class, the event need to update a worksheet, but when the user is editing a cell the update fails with Application Error. Is there any way to detect wether a user is editing a cell (without trying to update one) and Cancel the users edit (maybe prompt first) so the update can go ahead? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable cell reference insertion with PageUp in cell edit mode. | Excel Discussion (Misc queries) | |||
Excel 2007-starts in cell edit mode | Excel Discussion (Misc queries) | |||
Cursor in edit mode | Excel Discussion (Misc queries) | |||
Is it possible to arrow to a different cell while in edit mode? | Excel Discussion (Misc queries) | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) |