-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
application.height
-
M
Excel UserForm size related to screen scaling
Is there any way to scale UserForm according to screen scaling? This code works for screen resolution, but it does not recognize screen scaling: With Me .StartUpPosition = 1 .Width = Application.Width * 0.85 .Height = Application.Height * 0.85 .Left =...- mrwad
- Thread
- application.height application.width scaling screen userform
- Replies: 1
- Forum: Excel Questions
-
L
HELP - Adjusting Worksheet Viewable Size to fit Smaller Monitors
On my user's screen I want to show the (A1:V37) range of cells in Worksheet1 The Width of (A1:V37) is 977 pixels The Height of (A1:V37) is 642 pixels If the users monitor size => 977X642 then everything works perfect - Scaling is 100% - (A1:V37) is centered on screen and offsets (Top:Left) are...- lnagel
- Thread
- application.height application.width monitor offset screen
- Replies: 2
- Forum: Excel Questions
-
N
Use VBA to resize the window
I'm trying to create a spreadsheet for a client that will automatically size itself to a specific size when it is opened. I've googled a dozen things, none of which seem to work. The most common seems to be this code: Sub SetWindowSize1() Application.WindowState = xlNormal...- NickDC1964
- Thread
- application.height resize size spreadsheet window
- Replies: 2
- Forum: Excel Questions
