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

Embed on your site



The best free VBA training on the web
I see people struggling with Excel every day and I want to help. That's why I'm giving away my 90-days to Master VBA eCourse and my entire personal macro library for free.

Let me join the wellsrPRO VBA Training program for free