Telling a procedure to end
I'm embarassed to be nearing the end of a beginners VBA course and still have
to ask questions like this:
How can you tell a procedure to stop when you are inside another procedure?
I have created a UserForm where if the user clicks Command Button "Listen"
it plays an mp3 file. I want that file to stop playing when the user clicks
the Command Button "Next".......But it just keeps on playing
I expected there would be a simple end, cancel, stop, finish, quit command.
But I can't get any of them to solve this
An example of one of my guesses is
Private Sub CMDnext_Click()
'Various other changes of values followed by.......
End Sub CMDlisten_Click
End Sub
Thanks once again
|