Display Picture & Play Sound for 5 seconds

This is a rough example of what needs to be done:

First, create a macro within a module to unload the userform, ie

Please Login or Register  to view this content.

Then, in the Userform_Initialize even, place code such as the following:

Please Login or Register  to view this content.

Let me know if this helps

Here's a different way I'm trying to show the picture and play sound. I now have the picture on a separate tab and when the user fills out their name, the form tab disappears and the Halloween tab with picture and sound appears for 5 seconds and then the form comes back.

Questions:
1- How do I get the code to run automatically? I only know how to get it to work via a button or stepping manually through the code.
2- How do I embed the .wav sound into the workbook? I've found a few practice sounds and have attached the links at the bottom of the hidden Halloween tab.
3- What is the proper code for the 5-second timeframe?

Please Login or Register  to view this content.

Here's the code that worked for anyone interested.

http://www.vbaexpress.com/forum/show...523#post228523