+ Reply to Thread
Results 1 to 4 of 4

VBA Editor Font Size

  1. #1
    Registered User
    Join Date
    12-21-2017
    Location
    Wokingham, England
    MS-Off Ver
    office 365 2013
    Posts
    46

    VBA Editor Font Size

    I am not sure whether this should be here or on a Windows 10 forum. Maybe a Forum Moderator would check it for me and relocate it if necessary. The problem affects the VBA editor but only manifests itself after a Windows reboot.

    I have a 4K monitor which I do know causes problems for Windows 10 especially relating to the VBA editor. The default VBA editor font size is so small that it is almost impossible to read, especially where quotes, commas and full stops are concerned.

    I have found that sometimes rebooting makes a difference in that the editor will respond to the option to increase the font size of the editor text, however this does not always survive a reboot.

    There is a connection between the size of the Excel splash screen and the font (crazy I know but there is). If the splash screen is a small rectangle with the text barely readable then the VBA text will be the same. Sometime the icons on the task bar are also affected although not every time.
    Excel Splash.JPG

    I am in the final stages of a major Excel VBA project and debugging code that can hardly be read is an absolute nightmare!

    This is a bit of a weird one and I have absolutely no idea where to start.

    Has anybody encountered this problem and knows of a reliable fix?

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    MS365 V.2406
    Posts
    2,310

    Re: VBA Editor Font Size

    I remember reading abut this problem a while back and it was a known bug that had no fix (back then, at least). Some people had successfully worked around the problem by changing the screen resolution.

  3. #3
    Registered User
    Join Date
    12-21-2017
    Location
    Wokingham, England
    MS-Off Ver
    office 365 2013
    Posts
    46

    Re: VBA Editor Font Size

    Hi Dangelor,
    Thanks for your prompt response, I wasn't expecting anything back as today is Boxing Day.

    I did some more searching after posting and found this link:

    https://www.eileenslounge.com/viewto...p?f=30&t=28268

    Its a bit convoluted and you need to scroll down a bit. The registry hack didn't work but the reference to scaling in the following post excerpt did:
    <<
    Re: Can't change vba project font size
    Post by HansV » 31 Oct 2017, 21:27

    The problem is mentioned in other forums, for example in Can't change font size in VBA Code Editor in MS Access 2016. It appears to be related to the text scaling setting in Windows, in Start > Settings > System:
    S1911.png
    S1911.png (3.17 KiB) Viewed 2320 times
    Some people report that the font size in the Visual Basic Editor cannot be increased if text scaling is set to for example 200%, but it is possible if text scaling is set to 100%.
    In the thread I mentioned above, the original posted wrote that the problem was solved in an update to Office 2016 earlier this year. Is your Office fully updated?
    Regards,
    Hans
    >>
    In my case the scaling was set to automatic so I tried setting it to 100% and then changing the font size in VBA and, hey presto, it worked! lets hope it sticks.

    I will mark this as solved.

    If I have violated any forum rules by copying a link and a quote from another forum then please accept my apologies, I wanted to credit the author with the solution.

    Tegglet

  4. #4
    Registered User
    Join Date
    02-06-2023
    Location
    Stockholm, Sweden
    MS-Off Ver
    365
    Posts
    1

    Re: VBA Editor Font Size

    To change font size in VBE and 4K-resolution, disable "Let Windows try to fix apps so they're not blurry" under "Advanced scaling settings".
    Kind regards, mve

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 07-31-2021, 03:23 PM
  2. Editor Format Tab Font Size not changing
    By MarvinP in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2021, 12:42 AM
  3. How do you change the VBA Editor's font size when using a 4K Monitor?
    By Tegglet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2020, 11:30 AM
  4. [SOLVED] How to change the VBA Editor's font size?
    By Mariano B. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2020, 12:03 AM
  5. Refer .font.name, .font.size, line.dashstyle to a cell instead of hard coding.
    By avarshav in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2016, 11:50 AM
  6. Replies: 3
    Last Post: 07-06-2011, 01:30 PM
  7. [SOLVED] Dropdown list for font size, font type and number formats
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1