ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   countdown clock (https://www.excelbanter.com/excel-programming/378754-countdown-clock.html)

[email protected]

countdown clock
 
Hi, I have a simple countdown code for a stopwatch however it runs
faster than every second
does anybody know how I can rectify this?
thanks


Sub clockwork ()

Range("e12") = Range("e12") - TimeValue("00:00:01")
If Range("e12") = 0 Then End

'runs event every 1 second
NextTick = Now + TimeValue("00:00:01")
Application.OnTime NextTick, "clock"
End sub



All times are GMT +1. The time now is 01:58 AM.

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