Timer in Excel

[ryeire]

Hi all,

I am looking to create two buttons which control a timer in excel. I would like one button to start and reset the timer when pressed, and I would like the other button to stop the timer. Any help would be appreciated

 

[Micron]

Seems like you want a timer to just keep on advancing until you click stop button, but are you also watching a display advance, or just incrementing a timer you can't see? This would do the latter (assumes you have a start and stop button on a form). Note: save all work before running in case you get stuck in a loop and have to force a shutdown. I tested this in Access and it works without any issue, but basically does nothing except advance the built in timer.
This has to go in the declarations section (just under Option Explicit)

Public TimerValue As Variant

These are the button click events

Private Sub cmdStart_Click()

TimerValue = Timer
Do While TimerValue <> 0
   TimerValue = TimerValue + 1
   DoEvents
Loop

End Sub

Private Sub cmdStop_Click()
TimerValue = 0
End Sub

 

[ryeire]

This is perfect, I have no need to show the timer. Thank you very much

 

[Micron]

Glad to help. Can you mark this thread as solved if all done?