A splash screen is a screen which loads when you open a program. A splash screen can be used to display a company logo, advertise and provide information to the user.
To create a splash screen in Excel, you need to create a userform and then use some simple VBA to show the userform when opening a workbook, and make it disappear after a certain amount of time.
- Open the Visual Basic Editor by pressing Alt + F11
- Create a userform and set it up how you would like
- Double click on the ThisWorkbook project in the Project Explorer to open its code module and enter the code below (ComputergagaSplash is the name of the userform).
Private Sub Workbook_Open()
ComputergagaSplash.Show
End Sub
- Double click on the userform to open its code module, and enter the code below that uses the userform’s activate event. The activate event runs when the userform opens.
Private Sub Userform_Activate()
Application.OnTime Now + TimeValue("00:00:05"), "CloseForm"
End Sub
The OnTime method is used to set a time that in 5 seconds from now will run a procedure called CloseForm.
The TimeValue can be changed to set the timer of your choice.
- Open a code module and enter the following code to create a procedure called CloseForm that unloads the userform.
Private Sub CloseForm()
Unload ComputergagaSplash
End Sub
- Save and close the workbook. Open the workbook and the splash screen should display for 5 seconds.
Wizepiken says
How can i create a splarsh screen using ms-word
computergaga_blog says
I have not dabbled in MS Word VBA much but would imagine this activity being very similar.