Excel VBA Timer

[frankandsteph]

Hi All, I have been some digging, but can't seem to find what I am looking for in regards to a count-down timer. What I would like to do is to be able to set up 10+ countdown timers on a single page with a start/stop/pause button.

Each timer might be for a different time, say 15 minutes, 20 minutes, 1 hour, etc. Each would need it's own control button and hopefully make a noise when it counts down to 0.

is this possible? If so, any hints or tips on where to find it.

All the best, Frank

[mehmetcik]

You will need to use the Ontime Function.

This is best done on a Userform but is possible on a spreadsheet.

I will look at the Spreadsheet option first.

It will take me ten minutes.

Not Quite Ready.

But something to play with while I complete the code.

[frankandsteph]

Awesome, thanks for helping out.

[frankandsteph]

Maybe this will help for a format?

[mehmetcik]

Ok.

I have something for you to play with.

I will look at your amendments once you have played with it and what you want from it.

Not really sure what you want to occur when you select Stopped or Paused.

[frankandsteph]

Sorry, you are right, Stop and Pause are the same thing. What I am trying to do with my Start/Pause is control each timer independently. So I may have 10 timers in the sheet, but only use 5 this time hence why I am looking for each to have their own stop/start/reset ability. Column A,B,C,D are great but each timer needs its own countdown clock so we can monitor it. Am I doing an ok job describing this?

[mehmetcik]

We can work on this tomorrow.

Now I have the bulk of it working we should be ok.

[torachan]

curtsy of @Kellbellah? the ultimate in timing exercises

https://www.excelforum.com/excel-pro...p-timer-4.html

[frankandsteph]

This is perfect, with one issue. It crashes at Application.Speech.Speak (SayThis), any thoughts on why/how to fix it. I am running on a mac!

Please Login or Register  to view this content.

[torachan]

Override the following three lines of code by placing an apostrophe in front of each line.
If that does not work upload the attached file which is a far earlier version of mine.
The time periods that populate the timer dropdowns are hidden behind the black frame in column 'A' (A2 to A10)
A1 must be left blank as it gives the blank line at the start of the dropdown (use this to 'zero' a timer if needed)

Please Login or Register  to view this content.

[torachan]

Attached a far simpler app (partially developed to keep an eye on hospital patient absences).
type a number in 'green box' (column'I' "Timer") the number will be your minutes duration and press start.
The code is very repetitious (easy to extend by copy/paste) alter the obvious variable references.

[frankandsteph]

Opps, I can't run it cause I am using 64-bit!