PDA

View Full Version : Enable Maximize button and change userform size by manually dragging borders. VBA



tarekgemayel
07-17-2014, 04:18 AM
I have a userform that i have created in Excel. I can set its height and width from the properties tab.
However once i run the userform, i would like to have the option of changing the window size.

1) using the Maximize button beside the "Close" and "Minimize" button.
2) have the option of manually changing the size of the window by dragging, expanding or reducing the sides of the userform.

I cannot figure out how to solve this issue. It is really bugging me especially when i am working on PCs with big and small screens.

All help is appreciated
Thanks

GTO
07-17-2014, 04:28 AM
Try the download FormFun.zip at http://www.oaltd.co.uk/Excel/SBXLFrm.htm

I believe Mr. Bullen's example has min/max buttons as well as resize.

Mark

tarekgemayel
07-17-2014, 04:37 AM
Try the download FormFun.zip at http://www.oaltd.co.uk/Excel/SBXLFrm.htm

I believe Mr. Bullen's example has min/max buttons as well as resize.

Mark

woooow! it seems very complicated just for a simple action. By the way his code does not work on my PC since i have a 64-bit and his code is intended for 32-bit machines.