How To Create A Splash Screen In Microsoft Excel 2010

In this article, you will learn how to create a splash screen.

With splash screen appears as you open the excel file will impress the viewer.
 
We need to follow the below steps to launch VB editor

Click on Developer tab

From Code group select Visual Basic

 
img1
 
Click on Insert then UserForm
 
img2
 
The Userform will get open

From Toolbox; select Label & draw in the Userform
 
img3

 
img4
 
Rename the label box to “My Splash Screen”
 
img5
 
To increase the size of the font

Click on Label box & right click select Properties
 
img6
 
From Properties window; select Font & click three dots
 
img7
 
The Font dialog box will get open
 
img8
 
Select the font the way you want & increase the size to 20 or so to make it bigger
 
img9
 
The next step is to insert Image

From Toolbox select Image & draw a bit bigger
 
img10
 
img11
 
Right click on Image & select Properties

Click on three dots in Picture menu in Properties
 
img12
 
Select the path where the picture is saved
 
img13
 
This is how the Userform looks now
 
img14
 
Double-click on ThisWorkbook in Project pane
 
img15
 
Enter the following coding

Private Sub Workbook_Open()

UserForm1.Show

End Sub

 
img16
 
To initialize the userform; double click on the userform other than label or image
 
The following coding will appear

 

Private Sub UserForm_Click()

 

End Sub

 
img17
 
Replace the above code with the following code

Private Sub UserForm_Activate()

Application.OnTime Now + TimeValue(“00:00:05″), “Quitform”

End Sub

 
img18
 
Now, we need to add code to Quitform that we have assigned to Userform to get activated after 5 seconds.

Click on Insert then Module
 
img19
 
This will create new module.

Enter the following code in the Module

Sub Quitform()

Unload UserForm1

End Sub

 

 
img20
 
Save the file & then open it.
 
img21
 
In this way, we can create a splash screen in Excel.

 
 

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube