P
paulwes
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
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