User-Resizable Userforms in VBA, as an MS Excel 07 Macro

I have a user form I created for an excel 07 spreadsheet to manage my data, which is launched by a command button on the spreadsheet. It would be nice if it were possible for the user (me) to resize the form while running the program. In VB6 I am use to setting the "BorderStyle" property to "sizable", however there are only two options for the VBA userform and neither give the ability to resize. Is there any way to provide the user with the option of resizing the form?

I also noticed that there are no properties to set whether the userform has a min or max button. Is there any way to add those to the form as well?

Who is Participating?
Rory ArchibaldConnect With a Mentor Commented:
Have a look at the FormFun demo here:
It shows the code required for resizable forms as well as adding min/max buttons and some other stuff.
InvincibleShieldAuthor Commented:
Thanks this solution works great.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.