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

Becoming a VBA expert isn't hard
Over 5000 members are improving their VBA skills for free with our email tutorials. Why don't you join them? Our experts share time-saving VBA tips and we'll give you access to our huge macro library - it's sure to speed up your macro development.

I want to get your free VBA material

Embed on your site