Solved

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

Posted on 2009-07-09
2
914 Views
Last Modified: 2012-05-07
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?

Thanks.
0
Comment
Question by:InvincibleShield
2 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 125 total points
Comment Utility
Have a look at the FormFun demo here: http://www.oaltd.co.uk/Excel/Default.htm
It shows the code required for resizable forms as well as adding min/max buttons and some other stuff.
HTH
Rory
0
 
LVL 5

Author Closing Comment

by:InvincibleShield
Comment Utility
Thanks this solution works great.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now