Looking up color table

In Playing around with colors in VBA I introduced the concept of a color table. This is just a list of a name and a matching hex color code in a big excel table. I have been creating a large number of color schemes in the cDataSet.xlsm workbook, and each color is keyed on a color scheme name and a color name. We've filled in the other columns using the functions mentioned in Playing around with colors in VBA but only the name and hex value are of interest. Here's the start of the table showing some pantone colors


Making Swatches

We'll start with a simple example of using that table to create a color swatch, given a list of color names. This time we are going to choose colors from the dulux color scheme. They look like this in the color table. 


I'm just using these because they happen to be together - you can of course use any list or number of colors in the color table. 

We're aiming to create this swatch




And using the libraries in the cDataSet.xlsm workbook, here's the code 


create swatches from the color library

For help and more information join our forum,follow the blog or follow me on twitter.



Comments