Screen size
 

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

Screen size
 

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

--
gazornenpla

-----------------------------------------------------------------------
gazornenplat's Profile: http://www.excelforum.com/member.php...fo&userid=2449
View this thread: http://www.excelforum.com/showthread.php?threadid=38096

Screen size
 

Perhaps something like this may help

http://www.xcelfiles.com/VB_Quick14.htm

--
Ivan F Moal

-----------------------------------------------------------------------
Ivan F Moala's Profile: http://www.excelforum.com/member.php...nfo&userid=195
View this thread: http://www.excelforum.com/showthread.php?threadid=38096