Share via

Font size in VBA editor cannot be changed

Anonymous
2022-04-07T14:10:30+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-04-07T14:35:27+00:00

    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.

    Image

    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

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2022-04-07T15:02:13+00:00

    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

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments
  3. HansV 462.6K Reputation points
    2022-04-07T14:15:20+00:00

    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.

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments
  4. HansV 462.6K Reputation points
    2022-04-07T17:54:47+00:00

    I'm out of ideas, sorry.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. HansV 462.6K Reputation points
    2022-04-07T14:50:27+00:00

    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.

    Was this answer helpful?

    0 comments