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. 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.
Propriedades

ID do Artigo: 827710 - Última Revisão: 29 de abr de 2008 - Revisão: 1

Comentários