ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Minimize and Maximize Buttons VBA Forms (https://www.excelbanter.com/excel-programming/378518-re-minimize-maximize-buttons-vba-forms.html)

NickHK

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





All times are GMT +1. The time now is 10:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com