FG
💻 Software

How can I use custom colours in the Microsoft VBA editor?

Fresh7 days ago
Mar 15, 202662049 views
Confidence Score0%
0%

Problem

I'm working on a few projects for work using Excel and VBA, so I have no choice but to use the Microsoft Visual Basic editor. I normally wouldn't mind, but I can't figure out how to set a custom colour for the editor (I can only choose from the default palette). To change the colour currently, I go…

Error Output

Tools -> Options -> Editor Format

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How can I use custom colours in the Microsoft VBA editor?

Low Risk

VBA reads the settings for the colors from these registry keys: HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common\CodeForeColors HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common\CodeBackColors Each of these keys contains a list of values (separ…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment