![]() What we will need is a Non-Modal UserForm as a pop-up to ask to stop the alarm.įirst the macro code: Public Declare Function sndPlaySound32 Lib "winmm.dll" Alias "sndPlaySoundA" (ByVal lpszSoundName As String, ByVal uFlags As Long) As Long The best approach is to create a VBA Sound Alarm that will run in a loop until we Turn it Off manually. What if you don’t hear it? Running it once might obviously be not enough… VBA Sound Alarm ![]() SndPlaySound32 "C:\Windows\Media\Chimes.wav",
0 Comments
Leave a Reply. |