Solved: Splash Screen

[Djblois]

I want to be able to have a splash screen as my add-in installs but right now whenever I have a form show up all the code stops. How do I get the code to run in the background while my splash screen is up?

[Charlize]

userform1.show 0

[Bob Phillips]

It will, but you need to have code to automatically close down the form from within the form, issuing an OnTime command from the form initilaisation.

[Charlize]

some code
userform1.show 0
code to execute and you have to wait
at the end of the code use the next line
unload userform1

[Djblois]

Thank you that worked perfectly