Timer object
 

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

Timer object
 

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...Search& meta=

NickHK

"Satish" wrote in message
ups.com...
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

Timer object
 

Satish,

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

--
Robin Hammond
www.enhanceddatasystems.com


"NickHK" wrote in message
...
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...Search& meta=

NickHK

"Satish" wrote in message
ups.com...
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

Timer object
 

Cool, thanks Robin and Nick.

Robin Hammond wrote:
Satish,

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

--
Robin Hammond
www.enhanceddatasystems.com


"NickHK" wrote in message
...
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...Search& meta=

NickHK

"Satish" wrote in message
ups.com...
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