Hello everyone.
In the workbook is attached 1 userform.
To view this userform is the beep sound.
you can change the sound with another type "boom" (explosion).
I hope I explained.
max_max
-----------------------------------------------------------------------
Salve a tutti.
Nel workbook allegato c'è 1 userform.
Alla visualizzazione di questa userform c'è il sound beep.
è possibile cambiare il suono con un'altro tipo "boom" (esplosione).
Spero di essermi spiegato.
max_max
Hi Max,
Was there a question in your post? Or, were you simply showing us how to do something? If it was an example, you might want to put it in a different section. The section of Tips might be a*better place for this post.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
max,
If you are looking for a way to play a sound when your form opens, you can use something like this,
In a standard module:
The above path is the Windows 10 path for default system media files.
Public Declare Function sndPlaySound Lib "winmm.dll" _ Alias "sndPlaySoundA" (ByVal lpszSoundName As String, _ ByVal uFlags As Long) As Long Public Sub OpenFormWithSound() Userform1.show '-------------------- 'CHANGE THE PATH BELOW TO THE SOUND FILE YOU WISH TO PLAY sndPlaySound "C:\Windows\Media\Alarm07.wav", 1 End Sub
HTH,
Maud
Hello Maud
This line in your code would prevent the following to run till the form is closed
So I think it would be modelessUserform1.show
Userform1.show 0
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Yes, Thank you. Or play the sound prior to the form opening
Hello,
I inserted the macro in the module but it does not work.
max_max
Last edited by max_max; 02-05-2017 at 04:44 AM.
In ThisWorkbook module put this code instead
Private Sub Workbook_Open() OpenFormWithSound End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks