Resizing code for userform

[jaryszek]

Hi Guys,

i found this awesome code from @Andy Pope here:

https://www.andypope.info/vba/resizeform.htm

(you can download sample from this site)

Everything is working awesome but when you decrease userform only to top label size you have to turn off userform and start once again to increase its size once again:

Screenshot_48.png

Can i automatically expand userform in this case or not allow to fully decreasie userform size?

Best,
Jacek

[Andy Pope]

Add a couple of properties to the class which specify minimum width and height.
In the layout event check new values are not below the minimum sizes

[jaryszek]

Let me try what you just wrote.

And where can i put also resizing all objects within class?
I mean if i have commandbutton i want to resize it when i am resing userform in the same time?

Best,
Jacek

[Andy Pope]

See this on how to anchor/size controls
https://www.andypope.info/vba/Anchor.htm

An alternative is to use the zoom factor of the userform

[jaryszek]

thank you!!!!

Jacek