-
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.width
-
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
-
R
Excel : VBA : Userform in full screen mode
Dear All, I have created one userform which has the width of 1022.25 additionally in order to run it in full screen mode. I had used the below quoted VBA CODE. Quote Private Sub UserForm_Activate() '**************************************************************** 'Opening userform in full...- RAKESH230583
- Thread
- application.width full me.width screen userform
- Replies: 5
- Forum: Excel Questions
