Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Interesting! I use Excel 2000, and I always see the "Calculate" event
first, followed by the "SelectionChange" event, regardless of whether I hit "Enter" or whether I select a different cell to enter the changed value into the previously edited cell. Would using only the "Change" event work for you, rather than using both the "Calculate" and "SelectionChange" events? It seems that this would be what you are really trying to capture. On my machine, the "Calculate" event occurs before the "Change" event, so your worksheet should be up-to-date before you attempt to write back to storage. You might be able to use Application.Calculate in your "Change" event handler to make sure the worksheet has been calculated anyway. -- Regards, Bill Renaud |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Click event on menu item is lost after first time firing of the event | Excel Programming | |||
Excel newWorkbook event not firing | Excel Programming | |||
New instance of excel.exe not firing newWorkbook event | Excel Programming | |||
New instance of excel.exe not firing newWorkbook event | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |