In the Visual Basic Editor, select Tools > Options...
Activate the Editor Format tab of the dialog.
You can select the font and font size here, as well as the colors used for various code elements.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello,
I have been looking for the answer to this problem and haven't found a successful solution till now. Can anyone help me out?
The font in the VBA editor cannot be changed at all. The font size is fixed to 8 points no matter what I do or intended to do. I have tried changing the font size in the registry editor, and changing font size in Accessibility > System with no success.
I am using Microsoft Excel 365, and Windows 11 home. Changing the display resolution or scale doesn't seem to make any difference. Besides, I just want to keep those settings unchanged and only change font size in VBA editor
Has anyone found a solution to this problem?
Thank you.
Manuel
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
In the Visual Basic Editor, select Tools > Options...
Activate the Editor Format tab of the dialog.
You can select the font and font size here, as well as the colors used for various code elements.
Thank you for your reply.
Of course, this is the first thing I did and didn't work. This change is not saved. I have contacted Microsoft support and apparently, there is no solution. This is weird because this problem has been there for years and Microsoft hasn't resolved this error. I have found this issue in posts from 2018 even earlier.
Manuel
In Windows, select Start > Settings > System. See if you see "Change the size of text, apps and other items" there (I know you don't want to change that, but we'll restore the original setting afterwards)
If not, click Display, you should see it there.
If it is not set to 100%, make a note of the current setting, then change it to 100%.
Then change the font size in the Visual Basic Editor, click OK, and quit all Office applications.
Then restore the size of text, apps and other items in Windows to the original setting.
Reopen Excel and check the font size in the VBE.
No. It didn't work.
When changing the font size it simply doesn't save any changes. After doing so, the font size is fixed to 8 points.
Manuel
I'm out of ideas, sorry.