How to set Timed event to recur.

[Random]

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

 

[Tom Ogilvy]

See Chip Pearsons page on Ontime

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

this isn't preemptive, however.

 

[Random]

That's the ticket! Thanks for the help.

Random