Countdown timer with progress bar and reset/pause features

[bar807]

Hello all,

I need some help to create a 60 seconds countdown timer with pause/resume and reset (back to 60 secs) I would also like it to have a progress bar which starts green, turns yellow and plays a tone when 30 seconds are remaining, and turns red in the last 10 seconds and plays 3 times the tone when time expires. (like the attached photo)

Thanks in advance

[saravnepali]

Try the link below

http://www.tushar-mehta.com/excel/so...countdown.html

[bar807]

Hi,

Thanks for your reply. I did try this one but its not compatible with a 64bit machine and the VBA is locked

[torachan]

Better late than never.
Give the attached ago.

Please Login or Register  to view this content.

[bar807]

Hi Torachan,

Thanks for your reply. The problem is that it is not working on my 64bit laptop. Is it possible to edit it to work on a 64bit please?

Regards

[torachan]

It is most likely the two 'declarations' at the start of the code.
As I am unable to test on 64 bit I have attached a link that should help you edit the code.

https://codekabinett.com/rdumps.php?...ion-vba-64-bit

[torachan]

Give the attached a try.
I have removed the two declarations and resorted to the basic beep.
It should work.

[bar807]

Oh God I am now seeing this! Got to search again for one as season is reopening....thanks buddy it works great!!

[bar807]

Hi Torachan. Is there any way I could get this timer in Full Screen?

[torachan]

Try this - small amount of flicker - will try to correct if annoying.
Press 'X' top right corner to dismiss.
torachan.

[bar807]

Dear Torachan,

Thanks for your new version. Size is much better like this, but as you said, sometimes there is some flickering. Have also noticed that timer is stopping at 1 (not at zero) like its loosing the last second? Dont want to be a pain in the*** :D

Something else which might seem very big for me but not for the coding experts Lately (after i asked for this timer a year ago) we have introduced a new rule in Pool where a player has 1 chance to add an extension of 45 seconds. Is there a way to add another button and when pressed, it adds 45 seconds to trem?
I was thinking of a function 'extend' which when pressed it will reset the timer to trem + 45 followed by a resume so the timer will keep going after the extension is performed. Actually 2 buttons 'extend 1' and 'extend 2'. They will both have the same function in terms of timer but each will differently decrease the number of extensions available for player 1 or player 2 respectively (They only have 1 chance so starting will be 1) also to include a button to reset extension counter

I have edited the userform to the way I would like it to show but I dont know how to code the functions I was just able to enlarge more the progress bar as when I compared your changes from the first timer to the second I was able to give the code some logic. I'm learning thanks :D

[torachan]

Leave it with me for a few days.

[bar807]

Leave it with me for a few days.

Thanks mate