ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   GetSystemMetrics32() [Screen Size and UserForms - pt 2] (https://www.excelbanter.com/excel-programming/273485-getsystemmetrics32-%5Bscreen-size-userforms-pt-2%5D.html)

Jason Gatsby

GetSystemMetrics32() [Screen Size and UserForms - pt 2]
 
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


All times are GMT +1. The time now is 12:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com