VBA to make Excel sound noise when done with countdown

With help from a few nice members I was able to get my countdown timer to work well. The only thing I would like to do it to add a bell/buzzer for 10 seconds when a countdown is complete. I can get a simple ding, but not a real bell/buzzer type alert. I am running on a mac if that matters.

Toughts?
-Frank

.
This is one method ... certain there are plenty more :

Please Login or Register  to view this content.

In your code where you have this line : If Range("d3").Value = 0 Then Exit Sub

Change to :

Please Login or Register  to view this content.

So in this case the .wav needs to be on the computer used. Is there a way to imbed that in the workbook so others can use it?

To Logit : you post a Windows code but the OP wrote he uses a MAC …

.
Apologies ... overlooked he was running a MAC.

If by chance the code works on your MAC, the easiest thing would be to use a .WAV file already in Windows.

I am not familiar with MACs ... so ... if by chance MAC doesn't use .was files ... again I apologize.

The link I refereed to in your previous post was developed for Mac.
Within the very comprehensive dialog there must be a guide as to the addition of sound.
I have briefly run your app and it suffers from similar problems that befell the original in the link refered to.
Yours is referring back to a common 'interval' in seven cases and gets out of 'sync' (speeds up/slows down/jumps/misses periods).
This was solved in the attached examples by assigning each timer their individual 'tick' constant.

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