Spalsh Screen

[Ody]

Hello all,

I have a splash screen I want to display while a macro runs. I've created all the necessary code based on information from this site (very helpful) but have a question about where to actually put the code as all the example I've seen are based on workbook open events.

I tried placing my code

UserForm1.Show

with in the macro I waned the splash screen to be displayed during but that doesn't work. Well, it does, but not as I intended. The splash screen pops up for the specified duration as part of the macro stopping the macro, then closes and the rest of the macro finishes running.

Do i need to call the splash screen from a certain point in the macro I wish it to be displayed during? I dont want the macro to stop running while the splash screen is showing. What am I missing here?

Thanks for any suggestions!

 

[Ody]

Re: Splash Screen

I was able to solve my problem, thankfully, but this has lead me to another.

My Splash Screen now sits atop my working macro but the splash screen is showing up blank? Any idea why this might be? Thanks!