Solved

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

Posted on 2009-07-09
2
921 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

773 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