Solved

Excel VBA code to fill monitor screen with splash screen

Posted on 2011-03-12
2
1,053 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

831 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