countdown clock

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop timer. 7
Can't stop a clock 1
How do i stop a clock in excel 0
Elapsed times > 24hrs 12
Count Timer Pause and Stop button 0
Workbook reminder 0
Can't Stop the clock 2
stuck on the timing refresh.... 6

Top