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

"BW" <[email protected]> wrote in message
news:[email protected]...
> 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 here:

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

Robin Hammond
www.enhanceddatasystems.com

"Rob Bovey" <[email protected]> wrote in message
news:[email protected]...
> "BW" <[email protected]> wrote in message
> news:[email protected]...
>> 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!