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:
-
On UserForm(UserForm1), grab the resize handle on the lower-right corner.
-
Drag UserForm1 to the appropriate size.
Method 2: Change the UserForm Properties
You can change the properties of the UserForm by following these steps:
-
Click the UserForm.
-
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 by following these steps:
-
Right-click your UserForm, and then click View Code.
-
In your UserForm macro, do both of the following:
Type UserForm1.Height = number, in which number is a number that is between 0 and +32,767. Higher values may also work, depending on your system configuration. Type UserForm1.Width = number, in which number is a number that is between 0 and +32,767. Higher values may also work, depending on your system configuration.