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.

A subscription to make the most of your time

Need more help?

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

Was this information helpful?

×