GetSystemMetrics32() [Screen Size and UserForms - pt 2]

  • Thread starter Thread starter Jason Gatsby
  • Start date Start date
J

Jason Gatsby

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
 
Back
Top