ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Timers (https://www.excelbanter.com/excel-programming/277150-timers.html)

Khai[_2_]

Timers
 
I'm trying to figure out the VBA Timer.. which is not at all like the VB
Timer.. =/

Does anyone have a timer object that I could set for a 1 second interval
that countsdown from 5:00 minutes?

-khai



Tom Ogilvy

Timers
 
Look at Chip Pearson's page on Application.OnTime

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy


"Khai" wrote in message
news:AbE9b.364739$cF.109163@rwcrnsc53...
I'm trying to figure out the VBA Timer.. which is not at all like the VB
Timer.. =/

Does anyone have a timer object that I could set for a 1 second interval
that countsdown from 5:00 minutes?

-khai





Khai[_2_]

Timers
 
Thanks - looks great! =D

"Tom Ogilvy" wrote in message
...
Look at Chip Pearson's page on Application.OnTime

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy


"Khai" wrote in message
news:AbE9b.364739$cF.109163@rwcrnsc53...
I'm trying to figure out the VBA Timer.. which is not at all like the VB
Timer.. =/

Does anyone have a timer object that I could set for a 1 second interval
that countsdown from 5:00 minutes?

-khai








All times are GMT +1. The time now is 06:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com