Excel countdown timer code needed

Can you please write a code for the following cells; see attachment

START
PAUSE/UNPAUSE
RESET

When I click on the START cell, I want the "Time" cell to display 20:00 (twenty minutes) and begin counting down.

I want to be able to Pause/UNPAUSE at anytime.

When I click on the RESET cell, I want the time to reset to 20:00 (twenty minutes).

Thank you

Hi SLStockwell and welcome to ExcelForum.

Thank you for uploading your file, as it makes answering your question a lot easier.

See the attached sample file which implements a 20 minute countdown timer. You should be able to adapt the code to your file. Please ask if you need additional help or have any questions.

There are three parts to the code:
a. ThisWorkbook module - startup and shutdown code.
b. Generic Timer code in the Ordinary Code Modlue 'Mod20MinuteTimer'.
c. Application specific Timer code in the Ordinary Code Modlue 'Mod20MinuteTimer'.

Lewis

---------------------------------
The complete code follows:
ThisWorkbook module:

Please Login or Register  to view this content.

Ordinary Code module 'Mod20MinuteTimer':

Please Login or Register  to view this content.

Hi Guys

The excel sheet of your works fantastic.

I have tried changing the time period from 20 minutes to 30 minutes by changing every occurrence of the number 20 into 30.

Could you let me know what I am doing wrong?

Also If I wanted to have six of the timers running on the one sheet, how could I do this. Obviously copying the module and assigning the display to a new grid would not suffice.

I need to track 6 fire fighting aircraft at once and they must make contact every thirty minutes or they are assumed as missing.

Any help would be fantastic

Regards Martin

Hi Martin and welcome to ExcelForum,

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Since this is your first post, I will attempt to help you. See the file associated with post #4 in the following thread. http://www.excelforum.com/excel-prog...wn-timers.html

If you need additional help, please do not use this thread. Start a new thread and reference any relevant threads.

You will get the best and quickest response if you post a sample workbook.Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Lewis

Hi,

I would like to insert 2 of the the Application.Speech.Speak.

My timer will be 60 seconds (this is for pool shot timer) and it needs to advice when 30 seconds remain and when time is up.

How do I insert the below to be triggered at the correct time?

Sub thirtyseconds()
Application.Speech.Speak "30 seconds"
End Sub
Sub Timefoul()
Application.Speech.Speak "Time Foul"
End Sub

Also, beside the countdown timer I would like to insert a progress bar to indicate, preferably turning red in the last 10 seconds

Hi bar807 and welcome to ExcelForum,

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Since this is your first post, I will attempt to help you. See the file associated with post #4 in the following thread. http://www.excelforum.com/excel-prog...wn-timers.html

If you need additional help, please do not use this thread. Start a new thread and reference any relevant threads.

You will get the best and quickest response if you post a sample workbook.Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic


---------------------------------


Administrative Note:
When you make your post
a. You can make a reference to the URL of this thread
b. You MUST add 'code tags' or your question will not be answered.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Lewis