Screen Size and UserForms

[Jason Gatsby]

Hi

- I am using MS Visual Basic Version 6.0 (Version 8435,
VBA Retail: 6.0.8435, Forms3: 2.01) and MS Excel Version
2000 (9.0.2720).

- How do I determine the screen size? I would like to be
able to place UserForms anywhere on the screen, and
UsableHeight, UsableWidth are not the right ones. Didn't
want to waste time figuring out title bar heights, menu
heights, etc. There used to be a screen object...

Any ideas???

Thanks -J

 

[Harald Staff]

Hi J

See John Walkenbach's
http://j-walk.com/ss/excel/tips/tip06.htm
on this

 

[Tom Ogilvy]

another source, although not exactly what you want, but might provide useful
information:

http://www.cpearson.com/excel/FormPosition.htm

Chip Pearson's site on positioning a useform with respect to a cell
location.

Regards,
Tom Ogilvy