Create splash screen using Excel VBA

How to create a splash screen using Excel VBA. What is a splash screen? You would have noticed how a splash screen appears when you power on your Windows computer or start a program like MS-Word or MS-Excel. The splash screen normally contains an image or logo, the name of the software and its version. What we want to do today is to launch a splash screen when we open an Excel file and the splash screen then disappears in a few seconds so that we can start working in one of the Excel worksheets. So the process involves:

  1. We first design a splash screen using a user-form. In the user-form we place an image control and inside the control we place an appropriate image. In a similar manner we place a label control with an appropriate caption. We can adjust the background of the label and the image control. Als we remove the caption of the user-form
  2. Now we code the ‘ThisWorkbook’ option in the Visual Basic ¬†Editor window so that the splash screen appears when we open the workbook
  3. Next we code the user-form in such a way that when the user-form is activated it should close after a few defined seconds. To do this we use the ‘Timer’. This timer finally calls a macro in a module that closes the splash screen after specific number of seconds,

Watch the training video and then study the code:

Code for ‘This WorkBook’:

Private Sub Workbook_Open()
End Sub

Code for the user-form:

Private Sub UserForm_Activate()
Application.OnTime Now + TimeValue(“00:00:07”), “CloseForm”
End Sub

VBA code to close the user-form:

Private Sub CloseForm()
Unload UserForm1
End Sub

Download a sample Excel file for practice:

Further reading:
3 tips to create a great splash screen for your mobile app

View the video on YouTube.

Published by

Dinesh Kumar Takyar

Welcome to! My aim is to help you learn MS Excel including VBA. I always felt that a good way to learn something was to find solutions to problems in that domain. That is why I share these Excel videos with you. Mostly these are questions asked during my corporate training sessions. I've been training individuals and companies in computers since 1991. I did my B. Sc. (Vordiplom), M. Sc. (Diplom) and Ph.D. (Dr. rer. nat.) from Hamburg, Germany. The best thing about solving some of my visitor's questions is that I also gain new insights. For more Excel VBA solutions you may like to visit my YouTube channel: For a structured Excel VBA training course online you can visit:

Leave a Reply

Your email address will not be published. Required fields are marked *