Microsoft Office Tutorials and References
In Depth Information
Creating a Splash Screen
Follow these instructions to create a splash screen for your project:
Create your workbook.
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 .
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.
Insert the following procedure into the code module for the ThisWorkbook object:
Private Sub Workbook_Open()
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 + _