Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 45
Default 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





  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stopping a Timer / Running a timer simultaneously on Excel Paul23 Excel Discussion (Misc queries) 1 March 10th 06 12:08 PM
Using a timer Tha BeatMaker[_9_] Excel Programming 3 August 4th 05 04:00 AM
A couple RTD related questions, plus VBA timer object blindbl Excel Programming 4 May 9th 05 03:41 AM
Confusion about how the Window object fits into the Excel object model Josh Sale Excel Programming 11 April 15th 05 06:08 PM
Timer TJ Excel Programming 1 July 9th 04 03:18 PM


All times are GMT +1. The time now is 03:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"