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