Solved

Excel VBA code to fill monitor screen with splash screen

Posted on 2011-03-12
2
1,043 Views
Last Modified: 2012-05-11
How can I automatically size a splash screen to fill the monitor screen?
I need it to shrink to any size monitor and expand to max 17inch diagonally  

Thanks, --Andres
0
Comment
Question by:AndresHernando
2 Comments
 
LVL 24

Accepted Solution

by:
jimyX earned 500 total points
ID: 35115633
After creating the splash screen, the link below will help you doing so:
http://www.ozgrid.com/Excel/excel-splash-screen.htm

Only change the code of Initialize() to be as follows:
Private Sub UserForm_Initialize()
    Application.WindowState = xlMaximized
    Me.Top = Application.Top
    Me.Left = Application.Left
    Me.Height = Application.Height
    Me.Width = Application.Width
    Application.OnTime Now + TimeValue("00:00:05"), "KillForm"
End Sub

Open in new window

The above code will set the size of the splash screen to the size of the application window itself so in order to cover the whole screen then the application is maximized so the splash covers the screen.
0
 

Author Closing Comment

by:AndresHernando
ID: 35115648
Perfect.  Thanks!!!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Exchange server is not supported in any cloud-hosted platform (other than Azure with Azure Premium Storage).
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
This video discusses moving either the default database or any database to a new volume.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now