Important: Support for Office 2016 and Office 2019 will end on October 14, 2025. Upgrade to Microsoft 365 to work anywhere from any device and continue to receive support. Get Microsoft 365
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 theMinimize 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.
