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