Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Excel VBA code to fill monitor screen with splash screen

Posted on 2011-03-12
2
Medium Priority
?
1,132 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 24

Accepted Solution

by:
jimyX earned 2000 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Are you an Exchange administrator employed with an organization? And, have you encountered a corrupt Exchange database due to which you are not able to open its EDB file. This article will explain all the steps to repair corrupt Exchange database.
The main intent of this article is to make you aware of ‘Exchange fail to mount’ error, its effects, causes, and solution.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
how to add IIS SMTP to handle application/Scanner relays into office 365.

618 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