Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) | |||
Using a timer | Excel Programming | |||
A couple RTD related questions, plus VBA timer object | Excel Programming | |||
Confusion about how the Window object fits into the Excel object model | Excel Programming | |||
Timer | Excel Programming |