View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How to set Timed event to recur.

See Chip Pearsons page on Ontime

http://www.cpearson.com/excel/ontime.htm

this isn't preemptive, however.

--
Regards,
Tom Ogilvy


Random <Random@nwhere wrote in message
...
Hello all,

Does anyone know how to cause an event to occur at set intervals
whenever the worksheet is open?

An example of this would be causing the value of a cell to show the
current time every 10 seconds. I can't seem to figure out what to use
to trigger the event to occur. In VB, I would simply use a timer; is
there such a tool iln VBA?

Thanks for any responses,

Random