golf4
Active Member
- Joined
- Jul 8, 2002
- Messages
- 452
Hi, everyone -
I have one additional question on the use of wav files. I'm now using wavs throughout integral part of my income calculation tool (THANKS, JACOB!!!) I have one more question on wavs in my opening splash. I was looking to use two different wavs on the splash --- one right after the other. My modified code is below:
Private Sub UserForm_Activate()
Application.ScreenUpdating = True
DoEvents
ActiveSheet.Shapes("object 201.wav").Select 'hockey theme'
Selection.Verb Verb:=xlPrimary
ActiveSheet.Shapes("object 202.wav").Select 'welcome message'
Selection.Verb Verb:=xlPrimary
Application.OnTime Now + TimeValue("00:00:015"), "KillTheForm"
End Sub
What seems to be happening is that both wav files are playing at the same time. Since this will, probably, be the only place where I will use two wavs, I'm wondering whether there was a code strip that will allow me to play one file AFTER the other?
Thanks for the help,
Golf
I have one additional question on the use of wav files. I'm now using wavs throughout integral part of my income calculation tool (THANKS, JACOB!!!) I have one more question on wavs in my opening splash. I was looking to use two different wavs on the splash --- one right after the other. My modified code is below:
Private Sub UserForm_Activate()
Application.ScreenUpdating = True
DoEvents
ActiveSheet.Shapes("object 201.wav").Select 'hockey theme'
Selection.Verb Verb:=xlPrimary
ActiveSheet.Shapes("object 202.wav").Select 'welcome message'
Selection.Verb Verb:=xlPrimary
Application.OnTime Now + TimeValue("00:00:015"), "KillTheForm"
End Sub
What seems to be happening is that both wav files are playing at the same time. Since this will, probably, be the only place where I will use two wavs, I'm wondering whether there was a code strip that will allow me to play one file AFTER the other?
Thanks for the help,
Golf