View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_5_] Harald Staff[_5_] is offline
external usenet poster
 
Posts: 47
Default Screen Size and UserForms

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