• 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:

  • Create a Picture Lookup in Excel
    Create a Picture Lookup in Excel
  • Excel FILTER Function – The Best Function in Excel
    Excel FILTER Function – The Best Function in Excel
  • Create a Case Sensitive Lookup Formula in Excel
    Create a Case Sensitive Lookup Formula in Excel
  • Advanced Excel Skills
    Advanced Excel Skills

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

Recent Posts

  • LIVE Currency Exchange Rate in Excel
  • N Function in Excel
  • Non-Adjacent Columns with FILTER Function
  • Moving Average in Excel
  • Excel IMAGE Function – Insert Images from a Cell Value
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 2009 Computergaga · All Rights Reserved ·