• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / VBA / Create a Splash Screen in Excel

Create a Splash Screen in Excel

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.

  1. Open the Visual Basic Editor by pressing Alt + F11
  2. Create a userform and set it up how you would like
Splash screen in Excel
  1. 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
  1. 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.

  1. 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
  1. Save and close the workbook. Open the workbook and the splash screen should display for 5 seconds.

Related Posts:

  • What You Need to Know About Dynamic Array Formulas in Excel
    What You Need to Know About Dynamic Array Formulas in Excel
  • Lookup Multiple Values in Excel
    Lookup Multiple Values in Excel
  • Excel FILTER Function – The Best Function in Excel
    Excel FILTER Function – The Best Function in Excel
  • Create a Picture Lookup in Excel
    Create a Picture Lookup in Excel

Reader Interactions

Comments

  1. Wizepiken says

    26 September 2012 at 7:49 am

    How can i create a splarsh screen using ms-word

    Reply
    • computergaga_blog says

      1 October 2012 at 11:41 am

      I have not dabbled in MS Word VBA much but would imagine this activity being very similar.

      Reply

Leave a Reply Cancel reply

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

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Hyperlink to a Hidden Worksheet in Excel
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • Conditional Formatting Multiple Columns – 3 Examples
  • IF Function in Power Query Including Nested IFS

Recent Posts

  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
  • Advanced SUM Function Examples – The Power of SUM
  • Display Negative Time in Excel
  • Lookup Multiple Values in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2020 Computergaga · All Rights Reserved ·