Play .wav file when user form opens

[paulralph86]

Hi guys,

I have a workbook that on opening, uploads a user form login page. Following the login, the login user form closes and opens the main user form. I want to have a welcome message play once only when the main user form opens. I've tried googling various ways to do it but so far I've been unsuccessful.

The main user form name is userform_E
The sound clip file path is C:\Users\PRa\Music\welcome.wav

I'd appreciate any help you can give me.

Thanks,
Paul

 

[Eric W]

At the top of a general Module in your VBA project put this:

Public Declare Function sndPlaySound32 Lib "winmm.dll" Alias "sndPlaySoundA" _
(ByVal lpszSoundName As String, ByVal uFlags As Long) As Long

then when you initialize/load the userform, put this line:

sndPlaySound32 "C:\Users\PRa\Music\welcome.wav", 1

 

[paulralph86]

Hi Eric,

Code worked perfectly! Many thanks for the help

Cheers,
Paul

 

[Eric W]

Happy to help!