Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi and thanks to Harald Staff and Tom Ogilivy for their
suggestions about determining screen size, which I posted later on last night. - I have chosen the GetSystemMetrics32() approach for determining the screen size. The FormPosition stuff is great, but too much. - So the new question is this: How do I convert the pixels returned by GetSystemMetrics32() to points, which is how Excel VBA wants them for UserForm coordinates? Here is what I know (not much): 1 point = 1/72"; I can get from Points to Pixels with PointsToScreenPixelsX and PointsToScreenPixelsY; I can get pixel density per inch through some of the WebOptions objects. - Still doesn't seem like I am close though... Thanks again, -J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Screen Size | Excel Worksheet Functions | |||
Screen Size ? | New Users to Excel | |||
change font size on screen, but prints in old size | Excel Discussion (Misc queries) | |||
Work sheet size relative to screen size | Excel Discussion (Misc queries) | |||
Screen Size and UserForms | Excel Programming |