How to control the size of a UserForm in Excel

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.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×