View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
blc[_3_] blc[_3_] is offline
external usenet poster
 
Posts: 6
Default Timer control for Excel VBA

I am *not* scheduling. I want to fire an event every 1 or 2 seconds, like the timer control in the Visual Basic 6.0 toolbox does.

Thanks,

blc

"Tom Ogilvy" wrote:

The answer is no, but if you are scheduling, then
See Chip Pearson's site for the Ontime method.

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

--
Regards,
Tom Ogilvy

"blc" wrote in message
...
Hello all,

I got an error when posting this originally so I am hoping this is not a

duplicate.

Anyways, does there exist a timer control for Excel VBA forms like there

does for VB6.0 forms?

If so, what is the reference so I may set it and have access to the timer

control to add to my Excel VBA form.

Thank you in advance,

blc