Fix an Excel VBA UserForm That Grows After Each Run
Question details
The user needs to prevent an Excel VBA UserForm from increasing in height and width each time it is displayed.

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

Check the UserForm dimensions and isolate workbook-specific causes
Use this approach if the form still grows after you test consistent display settings.
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.

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.




