VBA & Macro Problems

How to Fix VBA Editor Font Size Not Changing in Excel

Maira MehtabMaira Mehtab Nov 3, 2026 869 views

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.

How to Fix VBA Editor Font Size Not Changing in Excel
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 you start

Before proceeding with troubleshooting, ensure that you have saved any open VBA projects and closed unnecessary workbooks to prevent accidental data loss.

Solution 1Recommended

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.

1
Open the VBA Editor

Press 'Alt + F11' while in Excel to open the Microsoft Visual Basic for Applications window.

2
Access Editor Format Options

In the top menu bar, click on 'Tools' and select 'Options'. Navigate to the 'Editor Format' tab.

3
Choose a Standard Size

In the 'Size' dropdown, select 8, 10, or 12. Avoid selecting 14 or higher, as these are known to trigger the display bug.

4
Apply and Verify

Click 'OK' to save the settings. Check your code window to see if the font size has successfully updated.

Select a Supported Standard Font Size
Recommended Fonts: For the best compatibility, use a standard monospaced font like 'Courier New' or 'Consolas' alongside these standard sizes.
Free Microsoft Office alternative

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. 1. Download and Install: Download WPS Office for free from the official website and complete the quick installation.
  2. 2. Open Your Macro Workbook: Launch WPS Spreadsheet and open your existing .xlsm or .xls files seamlessly.
  3. 3. Access the Macro Editor: Navigate to the 'Developer' tab and click on 'VBA Editor' to enjoy a smooth, fully adjustable coding environment.
100% format compatibility with Microsoft Excel (.xlsx, .xlsm, .xls)Built-in, stable VBA and Macro editor for seamless automationLightweight installation with fast loading timesFree to use with a clean, modern, and familiar interface
microsoft office alternative - wps office

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.