+ Reply to Thread
Results 1 to 5 of 5

Change the font and background color of the VBA code screen

  1. #1
    Registered User
    Join Date
    05-18-2012
    Location
    Norwalk, CT
    MS-Off Ver
    Excel 2010
    Posts
    80

    Change the font and background color of the VBA code screen

    Hi, I am not asking a VBA question per se.

    Is it possible to change the code part of the VB application... for example to ...white font and a black background....just to make it easier on the eyes ^^


    Thanks,
    Nick

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,428

    Re: Change the font and background color of the VBA code screen

    Yes.

    In VBE use tools > options > Editor Format.

    Change Foreground and Background colours from Auto to White and Black.

    Depending on your actual eye problem you can also increase the Font size.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127

    Re: Change the font and background color of the VBA code screen

    Hi Nick,

    In the Visual Basic Editor, go to TOOL -- OPTION.

    The options dialog box should open. Choose the EDITOR FORMAT tab. In here, you can play with the FOREGROUND (text) color, and BACKGROUND color.

    Let me know if this helps

  4. #4
    Registered User
    Join Date
    05-18-2012
    Location
    Norwalk, CT
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: Change the font and background color of the VBA code screen

    Thx for the help

  5. #5
    Registered User
    Join Date
    08-20-2021
    Location
    São Paulo
    MS-Off Ver
    2016
    Posts
    1

    Re: Change the font and background color of the VBA code screen

    dont know how to delete my reply
    Last edited by boriscasoy; 01-19-2022 at 10:04 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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