Consulting | Excel Examples

Displaying a Sequence of Colors in a Picture

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.

 

 

Last modified: May 21, 1996