Knowing VBA colors is handy when designing Excel spreadsheets and userforms. This infographic shows you 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


Discover how this Nuclear Engineer Mastered Excel VBA

And why you should, too


Your time is valuable. It's time to become a VBA expert.

About Ryan Wells


Ryan Wells

Ryan Wells is a Nuclear Engineer and professional VBA Developer. He is the lead developer of several VBA applications, including PDF VBA - a leading Excel Add-in for exporting Excel Objects, like charts and tables, to PDFs. Discover more of his popular Excel Add-ins, including Mouse To Macro and CF Shapes, at his dedicated Excel Add-ins page.