Fix Excel Button and UserForm Layout Differences Across Screens
Question details
The user needs Excel worksheet buttons and VBA UserForms to display consistently across computers with different screen settings.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- An Excel workbook with buttons and VBA UserForms is used on computers with different display and software configurations.
- Observed behavior
- Buttons and form controls can shift, and text may appear oversized on some screens.
Compare the affected computers' display scaling, screen resolution, Excel version, and installed fonts. Note the worksheet zoom level and which buttons or UserForms display differently.
Compare display settings and set button properties
Use this approach to identify configuration differences and make worksheet button dimensions and placement more predictable.
On each Windows computer, open Settings > System > Display and check Scale and Display resolution. Test with matching settings where practical, then reopen Excel.
In Excel, open File > Account to compare Office versions. Select the affected button and check its font and size; confirm that the same font is installed on each computer.
Right-click a worksheet button and open Format Control or Size and Properties, depending on its type. Set its height and width, then review the placement options, such as whether it moves or sizes with cells.
For an ActiveX button, select Developer > Design Mode, right-click the button, and choose Properties. Review its dimensions, font, and placement settings, then turn off Design Mode.
Use the zoom control at the bottom of Excel to compare the worksheet at the same zoom percentage on each computer. Recheck the layout under the display settings users normally use.

Adjust and test VBA UserForm layouts
Use this approach when a VBA UserForm or its controls change size or position on different screens.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its support for common Excel formats can make moving everyday workbook work straightforward, although it does not fix Microsoft Excel's VBA UserForm scaling behavior.

Frequently Asked Questions
Why does my Excel UserForm look different on another computer?
Display scaling, resolution, installed fonts, and Office versions can affect how a UserForm renders. Compare those settings on both computers and test the form under the configurations users actually use.
Where can I check display scaling in Windows?
Open Settings > System > Display and look for Scale and Display resolution. After changing a setting for testing, reopen Excel and check the workbook again.
How do I stop a worksheet button from moving with cells?
Right-click the button and open Format Control or Size and Properties. Under its placement or properties options, choose the setting that keeps it from moving or sizing with cells, if available for that control type.
Will changing worksheet zoom fix a VBA UserForm?
Worksheet zoom affects the worksheet view, not necessarily the VBA UserForm. Check UserForm control properties in Developer > Visual Basic and test the form separately.
Can WPS Office fix Excel VBA UserForm scaling?
No. WPS Office is an alternative for working with spreadsheets, not a fix for Excel's UserForm scaling. Test any workbook that depends on VBA macros or UserForms before relying on it in another application.




