Timer control for Excel VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Not sure what type of Timer you're after.

I have some examples on my website. Schedule a macro by API, Subsecond Wait,
Speed Test Range Reads


--
Rob van Gelder - http://www.vangelder.co.nz/excel


blc said:
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
Click to expand...
control to add to my Excel VBA form.
 
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 said:
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
Click to expand...
control to add to my Excel VBA form.
 
The timer control I was refering to is in the Toolbox for Visual Basic 6.0.

It is part of the common controls. You can set the "interval" for the Timer event. For instance you can set the timer to fire the "Timer" event every 1 or 2 seconds. Whatever code is inside the timer event gets executed. I thought this was a common control...

Thanks again in advance,

blc
 
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
 
Maybe I'm confused, but "fire an event every 1 or 2 seconds" and scheduling
are the same thing.

Excel's OnTime has issues. Yes, the issues can all be addressed, but it's
still a pain to use.
Suggest you use SetTimer API as on Chip's page. Examples on my website for
firing every 2 seconds.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


blc said:
I am *not* scheduling. I want to fire an event every 1 or 2 seconds, like
Click to expand...
the timer control in the Visual Basic 6.0 toolbox does.
 
Back
Top