How to control the size of a UserForm in Excel (827710)

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:
   • Type UserForm1.Height = number, where 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, where number is a number that is between 0 and +32,767. Higher values may also work, depending on your system configuration.