| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set up countdown timer to countdown days to a specific day | Excel Worksheet Functions | |||
| How to insert a 2 minute countdown clock in excel test? | Excel Discussion (Misc queries) | |||
| Countdown Clock | Excel Discussion (Misc queries) | |||
| Change EXCEL Clock to Standard Clock or Military Time | Excel Worksheet Functions | |||
| can i get a cell to countdown with the computer clock in excel | Excel Discussion (Misc queries) | |||
Linear Mode
