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

"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

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

Thanks Gentlemen. I will have a look at both!