determining coordinates for screen placement of user form
 

I set the StartupPosition of a UserForm to manual and wish to place it,
for example, in the lower right corner of the screen.

I use the API GetSystemMetrics function to return a screen width and
height, but then have to scale those measures down before subtracting
the width and height of the UserForm itself (to 60% for my 1400 x 1050
screen and 75% for my 1024 x 768 screen).

In other words, the screen width for UserForm placement purposes is
only 840 x 630 for a 1400 x 1050 screen and only 768 x 576 for a 1024 x
768 screen.

Question: Is there a way to determine this "scaling" factor
dynamically, so that the application always places the form where I
want it, regardless of the user's screen resolution?

I am sure this has been addressed many times, but my searches came up
empty. Any direction on this would be greatly appreciated. Thanks in
advance. :)


---
Message posted from http://www.ExcelForum.com/

determining coordinates for screen placement of user form
 

Pat,

You might find my FormPositioner code useful. See
http://www.cpearson.com/excel/FormPosition.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"PatFinegan " wrote
in message ...
I set the StartupPosition of a UserForm to manual and wish to
place it,
for example, in the lower right corner of the screen.

I use the API GetSystemMetrics function to return a screen
width and
height, but then have to scale those measures down before
subtracting
the width and height of the UserForm itself (to 60% for my 1400
x 1050
screen and 75% for my 1024 x 768 screen).

In other words, the screen width for UserForm placement
purposes is
only 840 x 630 for a 1400 x 1050 screen and only 768 x 576 for
a 1024 x
768 screen.

Question: Is there a way to determine this "scaling" factor
dynamically, so that the application always places the form
where I
want it, regardless of the user's screen resolution?

I am sure this has been addressed many times, but my searches
came up
empty. Any direction on this would be greatly appreciated.
Thanks in
advance. :)


---
Message posted from http://www.ExcelForum.com/

determining coordinates for screen placement of user form
 

Thanks for the reference. Not sure my understanding is correct, but th
calculations seem tethered to the Application and ActiveWindow'
dimensions, as well as to a particular cell's coordinates.

I need something slightly different -- namely, the Form compatibl
coordinates of the lower right corner of the screen itself.

Purpose: 2 side-by-side or vertically positioned forms that shouldn'
run off the screen.

I can obviously figure out the conversion ratio manually, as I did i
my original post, by changing my screen resolution and experimenting
but it seems very inelegant. And doesn't help me for resolutions beyon
my monitor's maximum. I guess I can visit CompUSA and pretend I'
interested in a big monitor.

Please let me know if I've missed something. Thanks again

--
Message posted from http://www.ExcelForum.com