View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Minimize and Maximize Buttons VBA Forms

Baapi,
Min/Max:
http://www.tek-tips.com/faqs.cfm?fid=4773

You can add use some variables to a module to store the position/dimension
and reset the form the next time it is shown.

NickHK

"Baapi" wrote in message
...
How to get Minimize and Maximize buttons on the user forms? by default, I
only get the cancel button.

and is there a way to store the screen size that the user sets to allow

them
to open the forms in their set size, every time they run the macro?

OR

Is there a way to make the form size equal to the screen size (to allow
users with different monitor sizes to have the screen properly)?

Thanks,
--
Baapi