-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to set sound alert !
- Thread starter danial
- Start date
Andrew Fergus
MrExcel MVP
- Joined
- Sep 9, 2004
- Messages
- 5,452
- Office Version
- 365
- 2021
- 2016
- Platform
- Windows
Hi
Add this to the top of you code :
Add change your 'beep' line of code to this :
Change the file path and name to suit - you can pass a string variable instead of specifying the file path and name. Also, the 0 at the end signifies that the code must wait for the sound to finish before continuing to run . If you want the code to keep running while the sound is playing, change the 0 to 1.
HTH, Andrew
Add this to the top of you code :
Code:
Private Declare Function sndPlaySound Lib "winmm.dll" _
Alias "sndPlaySoundA" (ByVal lpszSoundName As String, _
ByVal uFlags As Long) As LongAdd change your 'beep' line of code to this :
Code:
sndPlaySound "C:\WINDOWS\Media\tada.wav", 0Change the file path and name to suit - you can pass a string variable instead of specifying the file path and name. Also, the 0 at the end signifies that the code must wait for the sound to finish before continuing to run . If you want the code to keep running while the sound is playing, change the 0 to 1.
HTH, Andrew
Upvote
0
