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.

Published by

Dinesh Kumar Takyar

Welcome to exceltrainingvideos.com! 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: http://youtube.com/familycomputerclub For a structured Excel VBA training course online you can visit: https://www.youtube.com/excelvbaonline

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.