Using Excel picklist to change an icon in a cell?

[smooveb]

Hi!

I know I could use a picklist within excel to change something like the color or conditional formatting of a cell. However, is there a way I can also get an icon to change?

What I'd like to do is us a picklist (stop, yield, etc) of words to change the icon (stop sign, yield sign, etc) in a cell next to it.

Thanks in advance for any ideas!
Barrett

 

[SkipVought]

Barrett,

You could implement this EITHER with INTERNALLY stored icons or from external files.

For instance, internally, you could have a hidden sheet containing your icons, each with a name corresponding to your ombobox list. Then, use the selection to Copy the icon and Paste it in a cell...

Sheets("MyIconSheet").Shapes(Combobox1.value).Copy
Sheets("MySheet").Range("MyCell").PasteSpecial

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884