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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PointsToScreenPixels Documentation Incorrect 7
How to submit an MS Access Bug to Microsoft? Twips processing bug 2
Zoom at 100% is much smaller than true size 1
Screen Size and UserForms 2
Differing image length to width ratios for same pixel size images 0
Chart.Export max pixel size? 3
Links, Image Size, Display and Printing 1
Maximizing Userforms to suit any screen size 2

Top