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()
UserForm1.Show
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.

Leave a Reply

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