Timer control in VB available in VBA
 

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

Timer control in VB available in VBA
 

"BW" wrote in message
...
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

Timer control in VB available in VBA
 

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 he

http://www.enhanceddatasystems.com/E...ExcelTimer.htm

Robin Hammond
www.enhanceddatasystems.com

"Rob Bovey" wrote in message
...
"BW" wrote in message
...
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

Timer control in VB available in VBA
 

Thanks Gentlemen. I will have a look at both!