A splash screen is that thing that appears when you start a program. It’s designed to distract you from how long it takes to load the program. It’s also used for a little advertising or to nag you to register the software.
Here’s a simple way to create a splash screen for your program (written in Excel 2000 or higher). First create a userform
Then set the ShowModal property to False to show the form modelessly. When you show a form modeless, the code that shows it continues to execute while the form is showing.
Finally, code your program’s initialization procedure. There’s code in this example that shows the form for at least five seconds in case the initialization procedure runs to quick. If you go through the trouble of showing a splash screen, you’ll want to make sure that it’s visible long enough for the user to see it. If you have a lot of initialization stuff, you may be able to ignore that part altogether.
Dim dtDelay As Date
dtDelay = Now
‘Do initialization stuff
If Now < (dtDelay + TimeSerial(0, 0, 5)) Then
Application.Wait dtDelay + TimeSerial(0, 0, 5)