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!

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

--
Regards,
Tom Ogilvy


"dav135" wrote:

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!

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

On Thu, 14 Jun 2007 08:57:46 -0700, dav135
wrote:

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!