VBA ColorIndex lets you reference 56 pre-defined colors and even customize the default colors using VBA. There are also 8 named color constants.

Knowing VBA colors is handy when designing Excel spreadsheets and userforms. This infographic shows you each of the 8 named color constants and 56 ColorIndex colors for VBA.

The graphic is a great resource for all VBA developers because it includes examples of how to change the color of different spreadsheet elements and it presents some interesting facts about the 56 ColorIndex palette. For instance, did you know there are only 46 unique colors in the palette? Launch the infographic to learn more and share it with your friends.

VBA ColorIndex Color Infographic

Write better macros in half the time
Join thousands of others improving their VBA knowledge for free with our email series. Subscribe for more of our best VBA tips and access to our entire macro library.

I want to join the free VBA email series


Embed on your site