How to Create an Excel Splash Screen

In today’s world everyone loves splash screen appearing on the screen for few seconds as they open any file. Most of the people are unaware about splash screen. The viewer will surely get impressed.

We need to follow the below steps:

• Click on Developer tab
• From Code group select Visual Basic

• Click on Insert then UserForm

• The User form will get open
• From Toolbox; select Label & draw in the User form

• Rename the label box to “My Splash Screen”

• To increase the size of the font
• Click on Label box & right click select Properties

• From Properties window; select Font & click three dots

• The Font dialog box will get open

• Select the font the way you want & increase the size to 20 or so to make it bigger

• The next step is to insert Image
• From Toolbox select Image & draw a bit bigger

• Right click on Image & select Properties
• Click on three dots in Picture menu in Properties

• Select the path where the picture is saved

• This is how the Userform looks now

• Double-click on This Workbook in Project pane

Enter the following code in VBE:-

Private Sub Workbook_Open()

UserForm1.Show

End Sub

• To initialize the user form; double click on the user form other than label or image
• The following coding will appear

Replace the above code with the following code:-

Private Sub UserForm_Activate()

Application.OnTime Now + TimeValue("00:00:05"), "Quitform"

End Sub

• Now, we need to add code to Quit form that we have assigned to User form to get activated after 5 seconds.
• Click on Insert then Module

• This will create new module.
• Enter the following code in the Module

• Save the file & then open it.

By following this way we can create Splash Screen in Microsoft Excel through VBA.