Mike

Yes, there is a way.

You can employ event code and VLOOKUP with Data Validation list selection
to choose which picture to show?

See JE McGimpsey's site for more on lookuppics and a sample workbook.

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

Gord Dibben  MS Excel MVP

The VBA solution provided by JE McGimpsey is the generally accepted best
approach:
http://www.mcgimpsey.com/excel/lookuppics.html

However, as a new user, if you're not quite ready to jump into the VBA
programming pool this is an alternative non-VBA solution:

Assumption: Pictures are stored on Sheet2 to be dynamically shown on Sheet1.

Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
  1a. Insert>Picture from file. (select picture and put it in the sheet).
  1b. Select the range of cells that contains the picture.
  1c. Name that range of cells, using the prefix "pic" followed by the
dropdown list text:
Example for a picture of an Elephant:
Insert>Name>Define
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one of the
items.

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
...or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell on Sheet1.

5)With the picture selected, type this in the formula bar, then press [Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the dropdown list.

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP

Hi,

Here's a non vba solution from Jan Karel Pieterse.
http://www.jkp-ads.com/Articles/ShowPicture00.htm

Cheers
Andy

Thanks for the solutions offered. A non-VBA multi-event version is what I
need so I'll  either wait for Bernie or try the Jan karel solution.

Cheers

Mike

OK I can see how this is done (even if I couldn't create it myself) but how
the heck do I display the hidden pictures?  Also is there an easy way of
storing the pics in another sheet (I like to keep my data entry sheets as
clean as possible)

Thanks and apologies if the question is stupid

Cheers

Mike