Macro to change pictures

[dav135]

Hi, I'm working on a spreadsheet where, depeding on certain text which
is entered in a cell a picture is displayed.

If somebody changes the text in the cell I want the picture to change.
I've seen this done before but have no idea how - any ideas on the vba
code do do this?

*The picture doesn't have to change as soon as the cell is changed,
during runtime of a macro will do.

Thanks!

 

[Guest]

http://www.mcgimpsey.com/excel/lookuppics.html

 

[Gord Dibben]

To have a picture show up when you select an item from a DV list or type in a
name see JE MCGimpsey's site.

http://www.mcgimpsey.com/excel/lookuppics.html

OR Debra Dalgeish's site for a sample workbook from Bernie Dietrick for adding
pictures to selections.

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection


Gord Dibben MS Excel MVP