Microsoft KB Archive/827710

= How to control the size of a UserForm in Excel =

Article ID: 827710

Article Last Modified on 11/10/2006

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition

-





INTRODUCTION
This article describes how to control the size of a UserForm in Microsoft Excel.



MORE INFORMATION
Excel does not provide a method to control the size of a UserForm by using the Maximize button or the Minimize button. There are three methods to control the size of a UserForm.

Method 1: Manually size your UserForm
To manually size your UserForm, follow these steps:
 * 1) On UserForm(UserForm1), grab the resize handle on the lower-right corner.
 * 2) Drag UserForm1 to the appropriate size.

Method 2: Change the UserForm Properties
You can change the properties of the UserForm. To do so, follow these steps:
 * 1) Click the UserForm.
 * 2) In Properties - UserForm1, set the Height and the Width to the appropriate values.

Method 3: Specify the UserForm size in a macro
Program the appropriate size of the UserForm in your macro. To do so, follow these steps:
 * 1) Right-click your UserForm, and then click View Code.
 * 2) In your UserForm macro, do both of the following:
 * 3) * Type UserForm1.Height =, where   is a number that is between 0 and +32,767. Higher values may also work, depending on your system configuration.
 * 4) * Type UserForm1.Width =, where   is a number that is between 0 and +32,767. Higher values may also work, depending on your system configuration.

Additional query words: XL2007 XL2003 XL2002 XL2000 kbOffice2003yes Excel Visual Basic User Form Minimize Maximize

Keywords: kbhowto kbnofix KB827710

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.