Countdown Timer with Sounds

Hi Team

I am creating a simple countdown timer in excel but I need help on how to put sounds when the timer reaches 0:00:00.
Also I would like "Manual" button when click to show a pop up box where they can enter the time manually and that will be copied in cell Q2.

Here is the current code on my worksheet. I also attached the file for better understanding

Dim b As Boolean
Sub StartCountDown()
b = True
Do While b
Application.Wait (Now + #12:00:01 AM#)
DoEvents
If Sheets("Adjustment").Cells(2, "R") = #12:00:01 AM# Then Exit Sub
Sheets("Adjustment").Cells(2, "R") = Format(DateAdd("s", -1, Sheets("Adjustment").Cells(2, "R")), "hh:mm:ss")
Loop
End Sub
Sub PauseCountDown()
b = False
End Sub
Sub ResetCountDown()
b = False
Sheets("Adjustment").Cells(2, "R") = "00:15:00"
End Sub


Thank you in advance for any assistance

please put your code in TAGS. otherwise a moderator here will post a reference to the forum rules. you can play sounds in VBA by opening audio files. .WAV extensions are very common for this purpose. try this code to do that (on a 32-bit windows system only. code would have to include PTRSAFE in the API call if you are running 64 bit win OS):

Please Login or Register  to view this content.