Consulting | Excel Examples
Description: You can use a Visual Basic Macro to display a sequence of colors or images in a Picture on an Excel worksheet.
Tip: In Visual Basic for Applications, you can set a Picture equal to the value of a cell. The picture will then show the contents of the cell .... or the portion of another picture that overlays the cell.
Guide to the Example: A VBA macro is called from the Display Colors in Cell button. It displays the colors that overlay the cells A1 to A14.
Download File: Click Here
Tip: Click on the link above and choose "Save" to download the xls workbook to your hard drive or "Open" to open the workbook inside of your browser.