Play a WAV sound file when macro is activated

[mutzie]

Hello All,

As a short summary, I've requested help in a game buzzer style excel file to be used for a game activity and Davsth provided an excellent solution to the request. Again, Thank you Davsth for your assistance.

I would like to ask how can I make it so that when either of the 2 macros were activated, a buzzer sound will play (to complete the effect of a working game buzzer system) I have a buzzer.wav file that I have on my local drive.

Please see the attached file - The buzzer is composed mainly of 2 macros to activate Team A or Team B side, a reset button and a lock and unlock macro.

Thank you so much!

[Marc L]

Several ways, one as a demonstration starter :

Private Declare Function sndPlaySoundA Lib "winmm.dll" (ByVal fSon$, ByVal fuSound&) As Boolean

Sub Demo1()
    sndPlaySoundA "C:\Windows\Media\chimes.wav", 2
End Sub  

Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

[mutzie]

Hi Marc L, sorry but my VBA knowledge is primitive at best, can I ask further clarification on how it will be placed? on the module?

[Marc L]

To the top of the module …