Timer object

[Satish]

Hi,

Does anyone know how to add the timer object in VBA? I looked under
additional controls, but did not find it there. I am using Office xp.

Thanks for any replies
Satish

 

[NickHK]

There is no timer control in VBA as there is in VB5/6, but you can use a
class instead. Take your pick :
http://www.google.co.uk/search?hl=en&q=vba+timer+class&btnG=Google+Search&meta=

NickHK

 

[Robin Hammond]

Satish,

Try this for exact equivalent functionality to the vb version:
http://www.enhanceddatasystems.com/ED/Pages/ExcelTimer.htm

 

[Satish]

Cool, thanks Robin and Nick.

Satish,

Try this for exact equivalent functionality to the vb version:
http://www.enhanceddatasystems.com/ED/Pages/ExcelTimer.htm