How Can I Increase the Font Size of VBA Code in Subroutine Modules for Easier Reading?

Question

The vba code in the modules (subroutines) is too small to read. How do I make it larger so I can see it easier? The VBA version is whatever the version of Excel uses. The Excel version is "Excel for Microsoft 365".

Answer 1

Hi Eric,

Here's how you can do it:

• Open the VBA editor by pressing Alt+F11 or going to the "Developer" tab and clicking on the "Visual Basic" button.
• In the VBA editor, go to the "Tools" menu and select "Options."
• In the "Options" dialog box, navigate to the "Editor Format" tab.
• Under the "Font" section, choose a larger font size from the "Size" drop-down list. You can select a size that makes the code more readable for you.

Best Regards.

Answer 2

Tools\Options\Editor Format may work for you.

Answer 3

It may not work unless the operating system's Scale Layout is set to 100%

you can also provide this as feedback here.

-

--please don't forget to upvote and Accept as answer if the reply is helpful--

Answer 4

sorry to say those steps have no effect on my font size.

The steps I posted are the only method. If it does not work then you can reach out to support or report the feedback for this bug.

please don't forget to close up the thread here by marking answer.

Answer 5

These steps do not work. Change the size all you want and it just reverts to the same old size 9 as soon as you click OK.