Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timer w/ Start, Stop, Pause
I am trying to create a cell with a 1 hour 15 min 30 sec preset that when I
click "start", the cell will start counting down. I would also like to create a button that can pause, stop, or reset the timer. It would be great if the timer is paused and the workbook saved the time remains when the file is restarted. VBA code and instructions would be much appreciated! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timer w/ Start, Stop, Pause
Don't do this. Updating a cell will force a recalculation on every update,
and it will disturb the Undo functionality. I suggest you display your time on a label, or better, on a modeless "stopwatch-like" userform. There is some math involved with Pause functionality. Code and instructions will ruin the fun of figuring it out, but see http://www.cpearson.com/excel/OnTime.aspx to get started on timers. HTH. Best wishes Harald "dgold82" wrote in message ... I am trying to create a cell with a 1 hour 15 min 30 sec preset that when I click "start", the cell will start counting down. I would also like to create a button that can pause, stop, or reset the timer. It would be great if the timer is paused and the workbook saved the time remains when the file is restarted. VBA code and instructions would be much appreciated! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timer w/ Start, Stop, Pause
Thank you Harald. I am actually not concerned about the Undo functionality.
This will be a locked worksheet/workbook with no need for it. I like the link you gave me, but I am still curious if it can be done within cells with command buttons for start, stop, pause, and reset. "Harald Staff" wrote: Don't do this. Updating a cell will force a recalculation on every update, and it will disturb the Undo functionality. I suggest you display your time on a label, or better, on a modeless "stopwatch-like" userform. There is some math involved with Pause functionality. Code and instructions will ruin the fun of figuring it out, but see http://www.cpearson.com/excel/OnTime.aspx to get started on timers. HTH. Best wishes Harald "dgold82" wrote in message ... I am trying to create a cell with a 1 hour 15 min 30 sec preset that when I click "start", the cell will start counting down. I would also like to create a button that can pause, stop, or reset the timer. It would be great if the timer is paused and the workbook saved the time remains when the file is restarted. VBA code and instructions would be much appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop / Pause a Macro using Pause button | Excel Programming | |||
VBA Pause to allow Print to start. sending fax via Outlook | Excel Programming | |||
Pause Macro For Start Row While Parsing a Text File | Excel Programming | |||
stop timer | Excel Programming | |||
How to Pause or Stop a running Macro | Excel Programming |