![]() |
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