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 by following 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 by following 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, 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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×