Timer control in VB available in VBA

[Guest]

Hello,

I believe i read somewhere before, perhaps on this forum that the timer
control in VB is not available for VBA. Is this still true?

Thanks

 

[Rob Bovey]

I believe i read somewhere before, perhaps on this forum that the timer
control in VB is not available for VBA. Is this still true?

That's correct, but here's a very good substitute:

http://vb.mvps.org/samples/project.asp?id=timerobj

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[Robin Hammond]

I haven't tried Karl's solution that Rob refers to, but there is also an
activex version of the vb timer for use in Excel here:

http://www.enhanceddatasystems.com/ED/Pages/ExcelTimer.htm

Robin Hammond
www.enhanceddatasystems.com

 

[Guest]

Thanks Gentlemen. I will have a look at both!