The Dutchman
Board Regular
- Joined
- Apr 10, 2008
- Messages
- 72
I have embedded a wav file into a template. When you click on a commandbutton (caption is a hint to an answer) a 3 second countdown starts and then a bell chimes(embedded wav file) and the commandbutton caption shows the answer.
My problem is that when the wav file plays, sometime the Window Media Player screen pops up and sometimes it does not.
How can I suppress the Window Media Player from popping up? Just n FYI I used a mp3file and converted the file extension to wav. My code is as follows:
My problem is that when the wav file plays, sometime the Window Media Player screen pops up and sometimes it does not.
How can I suppress the Window Media Player from popping up? Just n FYI I used a mp3file and converted the file extension to wav. My code is as follows:
Code:
Private Sub CommandButton8_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
If CommandButton8.Caption = "John Doe" Then
CommandButton8.Caption = "I was the varsity athlete of the year... back in the day."
Else
If CommandButton8.Caption = "I was the varsity athlete of the year... back in the day." Then
UserForm3.Show
'THIS IS THE CODE I USED TO INTIATE THE EMBEDDED WAV FILE
Application.ScreenUpdating = False
Sheet1.OLEObjects("Object 29").Verb Verb:=xlPrimary
Application.ScreenUpdating = True
CommandButton8.Caption = "John Doe"
End If
End If
End Sub