How to Fix VBA Editor Font Size Not Changing in Excel
Question details
The user is unable to visually change the text size in the Excel VBA Editor, even though the new font settings appear to save successfully in the options menu.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to increase or modify the font size in the VBA code editor to improve code readability.
- Observed behavior
- Modifying the font size under Tools > Options > Editor Format does not visually update the text size in the code window, typically locking the display to standard small sizes.
Before proceeding with troubleshooting, ensure that you have saved any open VBA projects and closed unnecessary workbooks to prevent accidental data loss.
Select a Supported Standard Font Size
The VBA Editor has legacy scaling limitations and may only accept specific standard font sizes (such as 8, 10, or 12) depending on your system configuration.
Because the VBA Editor is an older component within Microsoft Office, it frequently struggles to render non-standard or very large font sizes correctly. Sticking to standard sizes that the engine natively supports is the most effective workaround.
Press 'Alt + F11' while in Excel to open the Microsoft Visual Basic for Applications window.
In the top menu bar, click on 'Tools' and select 'Options'. Navigate to the 'Editor Format' tab.
In the 'Size' dropdown, select 8, 10, or 12. Avoid selecting 14 or higher, as these are known to trigger the display bug.
Click 'OK' to save the settings. Check your code window to see if the font size has successfully updated.

Perform an Online Repair of Microsoft Office
If standard font sizes fail to apply across all your workbooks, your Office installation might have corrupted registry keys or application files that need repairing.
Experience Seamless Macro Editing with WPS Office
If you are frustrated by legacy interface bugs in Microsoft Excel's VBA editor, consider switching to WPS Office. It provides a lightweight, highly compatible Spreadsheet application with robust built-in support for VBA and macros, ensuring smooth coding without frustrating UI glitches.
- 1. Download and Install: Download WPS Office for free from the official website and complete the quick installation.
- 2. Open Your Macro Workbook: Launch WPS Spreadsheet and open your existing .xlsm or .xls files seamlessly.
- 3. Access the Macro Editor: Navigate to the 'Developer' tab and click on 'VBA Editor' to enjoy a smooth, fully adjustable coding environment.

Frequently Asked Questions
Why is my VBA Editor font appearing so small on a new monitor?
High-resolution (4K) displays often scale legacy applications like the VBA Editor poorly. Adjusting the Editor Format to a supported standard size or changing your overall Windows DPI scaling settings can help improve readability.
Does changing the default font size in Excel change it in the VBA Editor?
No, the VBA Editor operates independently from the main Excel interface. You must adjust its font settings specifically by navigating to Tools > Options > Editor Format inside the VBA window.
Are there alternative fonts that work better in the VBA Editor?
Yes, standard monospaced fonts such as 'Courier New', 'Consolas', or 'Fixedsys' at sizes 10 or 12 are generally the most stable and legible choices for VBA programming, minimizing rendering bugs.




