VBA & Macro Problems

Fix an Excel VBA UserForm That Grows After Each Run

John WilsonJohn Wilson Nov 13, 2026 870 views

Question details

The user needs to prevent an Excel VBA UserForm from increasing in height and width each time it is displayed.

Fix an Excel VBA UserForm That Grows After Each Run
Product
Microsoft Excel and the Visual Basic Editor
Device & OS
not provided
Scenario
The Visual Basic Editor is used on a 32-inch 4K monitor while the workbook is displayed on a 24-inch 1080p monitor. A third monitor uses a resolution of 1680 × 1050.
Observed behavior
The UserForm becomes larger after being closed and displayed again, and its Height and Width property values increase.
Before you start

Record the UserForm's current Height and Width in the Visual Basic Editor, along with each monitor's resolution and scaling percentage. Identify which monitor displays the editor and which displays the workbook when you run the form.

Solution 1Recommended

Use consistent display settings for the editor and workbook

Start here when the form grows while the editor and workbook are displayed on monitors with different resolutions or scaling settings.

Mixed display scaling can affect how Excel and the Visual Basic Editor size a UserForm. Keeping both windows on one monitor is a useful first test before changing your display configuration.

1
Test on one monitor

Move both the Excel workbook window and the Visual Basic Editor to the same monitor. Open the UserForm, close it, and open it again to check whether it still expands.

2
Compare display scaling

Open your operating system's display settings and select each monitor to compare its scaling and resolution. On Windows, right-click the desktop, choose Display settings, and check Scale and Display resolution for each display.

3
Align scaling where practical

Set the monitors used by Excel and the editor to the same scaling percentage where practical. Save your workbook, close all Excel windows, reopen Excel, and repeat the UserForm test.

4
Test a lower resolution on the 4K monitor

If matching scaling does not help, select the 4K monitor in display settings and temporarily choose a supported resolution comparable to the workbook monitor, such as 1920 × 1080. Keep the editor and workbook on those displays and test the form again.

Use consistent display settings for the editor and workbook
Lower resolution is a diagnostic workaround: Reducing a 4K display's resolution may prevent the expansion, but it can reduce image sharpness. If the same-monitor test works, keeping the editor and workbook together may be preferable.
Free Microsoft Office alternative

Use WPS Spreadsheet for everyday workbook editing

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Excel format compatibility, making migration straightforward for everyday workbooks. It does not fix Excel's VBA UserForm scaling issue; verify VBA support in your WPS edition before relying on macro-driven workflows.

Edit worksheet data and perform everyday calculations without opening a VBA UserForm.Supports Microsoft Excel .xlsx and .xls workbook formats.Familiar spreadsheet controls make routine workbook editing easy to learn.A lightweight option for everyday spreadsheet work alongside Excel.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my UserForm grow when I use a 4K monitor?

Different scaling settings across monitors can affect UserForm sizing when the Visual Basic Editor and workbook are displayed on separate screens. Move both windows to one monitor and run the form repeatedly to check whether the display setup is involved.

Do I have to lower my 4K monitor's resolution?

Not necessarily. First test the editor and workbook on the same monitor, then compare scaling percentages in your display settings. Lowering the 4K monitor to a supported resolution comparable to the other display is a workaround to test if those steps do not help.

Where can I check a UserForm's Height and Width?

Open Excel's Developer > Visual Basic, open the UserForm in Project Explorer, and select the form itself. Choose View > Properties Window to inspect Height and Width. Also check the form's code for assignments that change these properties during initialization or activation.

Will opening the workbook in WPS fix the VBA UserForm?

No. WPS does not repair Excel's display-scaling behavior. WPS Spreadsheet can be used for compatible worksheet editing, but VBA and UserForm support depend on the WPS edition and environment. Test compatibility before using a macro-dependent workbook.