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



Get wellsrPRO for Free

Get these macros delivered right to your spreadsheet for free

Access tutorials and import my macros without ever leaving Excel

Show me - It's free

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.