Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
J S J S is offline
external usenet poster
 
Posts: 11
Default Workbook_sheetChange event

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
workbook_sheetchange JulieD Excel Programming 1 June 14th 04 04:32 AM
How do I access the source cells in Workbook_SheetChange Arifi Koseoglu Excel Programming 5 February 27th 04 03:23 PM
Problem with the Workbook_SheetChange event??? angel Excel Programming 0 January 29th 04 02:56 PM
OnTime event not firing in Workbook_Open event procedure GingerTommy Excel Programming 0 September 24th 03 03:18 PM
Workbook_SheetChange will not fire Robert Willard Excel Programming 1 September 10th 03 07:52 PM


All times are GMT +1. The time now is 02:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"