vba timer
 

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

vba timer
 

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

Greetz,

Rody

"William Barnes" schreef in bericht
...
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

vba timer
 

Thanks for your prompt reply. Very helpful.
William

"Rody Meulman" wrote in message
...
http://www.cpearson.com/excel/ontime.htm

Greetz,

Rody

"William Barnes" schreef in bericht
...
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