Good morning everyone,
As you can see from the subject, I am playing around with creating a simple countdown timer in excel. The user inputs the hours, minutes, and seconds on the worksheet and then clicks the start button. This action calls up a userform that has the timer as well as two buttons - pause and stop. I have yet been able to figure out how to code within the timer loop to check for either of these two buttons getting clicked.
The stop button is self-explanatory. When the user clicks on the pause button, I want it to call up a message box that states "Timer Paused", which, of course, will suspend the timer loop until the user clicks the OK button on the message box. Also, I have found that the timer freezes is the mouse is clicked or any key on the keyboard is pressed, so is there any way to code in so that the only way the timer can be disrupted is pressing either the pause or stop button? Right now the timer part works perfectly except for the fact that it enters into an endless loop until the hours counter reaches zero or the user presses CTRL-Break.
Thanks to any and all who are able to assist in this. I have posted a copy of the file for your convenience.