Screen size

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Is there a way to have vb code (in Excel) determine the screensize /
resolution of the
computer used to view it. I have a spreadsheet that has custom userforms
that I have lined up along the right side on my screen, but when it opens
on another persons computer (with a narrower screen) the forms are cut off.
Is there a way to determine what the size of the actual display area is
(both width and height) so that I can adjust the positioning of the
userforms that I use.


Always find excellent answers in this group, I appreciate the help.

Jim
 
Don't think you can get the resolution but you can (optionally) maximiz
Excel, maximize the active pane and then get the number of point
available. You can then use *that* to set column widths & heighs, an
pick a font size to fit

EG


Application.WindowState = xlMaximized
With ActiveWindow
.WindowState = xlMaximized
MsgBox .Width
End With

Ga
 
Back
Top