Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet with some code that I need to run every time something
changes in my workbook. I can do this through the sheetChange event and it works fine except for the fact that the spreadsheet runs very slowly when a user makes a lot of changes in a short amount of time. What I am searching for, is a way to run my code only when there haven't been any changes in the last 5 seconds. Ex: If a user makes a change a 0sec then my update code will run at 5sec If a user makes a change at 0sec then another change at 4sec then my update code will only run once at 9sec. Any ideas of how to accomplish this in excel? maybe using custom events in a interesting way? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
workbook_sheetchange | Excel Programming | |||
How do I access the source cells in Workbook_SheetChange | Excel Programming | |||
Problem with the Workbook_SheetChange event??? | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming | |||
Workbook_SheetChange will not fire | Excel Programming |