Microsoft Office Tutorials and References
In Depth Information
Creating a Splash Screen
Follow these instructions to create a splash screen for your project:
1.
Create your workbook.
2.
Activate the Visual Basic Editor (VBE) and insert a new UserForm into the project.
The code in this example assumes that this form is named UserForm1 .
3.
Place any controls that you like on UserForm1 .
For example, you may want to insert an Image control that has your company’s logo.
Figure 14-4 shows an example.
Figure 14-4: This splash screen is displayed briefly when the workbook is opened.
4.
Insert the following procedure into the code module for the ThisWorkbook object:
Private Sub Workbook_Open()
UserForm1.Show
End Sub
5.
Insert the following procedure into the code module for UserForm1 .
For a delay other than five seconds, change the argument for the TimeValue function.
Private Sub UserForm_Activate()
Application.OnTime Now + _
TimeValue(“00:00:05”), “KillTheForm”
End Sub
 
Search JabSto ::




Custom Search