vba timer

[William Barnes]

Using Excel 2003 v11.2 SP1 on an XP Pro 2002 SP2 machine.

Is there a control available with the functionality of the Timer object
found in VB6? In searching for 'Timer' I only found examples of code using
the Timer function that typically saved the current time then looped until
the time was some increment greater, calling DoEvents inside the loop, in
order to effect a pause. I'm looking for a control I can instantiate that
will generate Tick() Events at programmable intervals.

Thanks
William Barnes

 

[Rody Meulman]

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

Greetz,

Rody

 

[William Barnes]

Thanks for your prompt reply. Very helpful.
William