Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Screen Size [email protected] Excel Worksheet Functions 0 May 25th 09 08:06 AM
Screen Size ? Robert11[_3_] New Users to Excel 3 March 18th 09 10:43 PM
change font size on screen, but prints in old size lvrcdval Excel Discussion (Misc queries) 2 July 19th 07 02:36 PM
Work sheet size relative to screen size Florida Tom Excel Discussion (Misc queries) 1 April 16th 07 02:22 AM
Screen Size and UserForms Jason Gatsby Excel Programming 2 August 4th 03 01:48 PM


All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"