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

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

That's the ticket! Thanks for the help.

Random


On Sat, 30 Aug 2003 14:04:22 -0400, "Tom Ogilvy"
wrote:

See Chip Pearsons page on Ontime

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

this isn't preemptive, however.