Solved

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

Posted on 2009-07-09
2
918 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
ID: 24821027
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
ID: 31601948
Thanks this solution works great.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Tags from access to excel 3 24
Configure Sharepoint 2013 to allow Excel files to be edited online 9 50
Highlighting cells in Excel 9 16
Update As Well As Add 6 32
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

947 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

19 Experts available now in Live!

Get 1:1 Help Now