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

Hi J

See John Walkenbach's
http://j-walk.com/ss/excel/tips/tip06.htm
on this
--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"Jason Gatsby" skrev i melding ...
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

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


"Jason Gatsby" wrote in message
...
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