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.