Hmmm....that method has worked since at least Excel 5.

Can you save your workbook at one of the free file sharing sites and post
the link here so we can see what issue you're encountering?

Some free filehosts that could be used:
http://www.flypicture.com/
http://cjoint.com/index.php
http://www.savefile.com/index.php

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Arvi Laanemets" wrote in message
...
Hi Ron

I was curious enough to test this non-VBA solution right away. For me
(Excel2000) it works, but only when:
1. I select an item from dropdown;
2. , activate the picture on Sheet1;
3. , and activate the formula bar (select end of formula with mouse) and
press Enter.

Otherwise the picture remains unchanged!


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Ron Coderre" wrote in message
...
Here are a few options:

If you want to read the pictures from a folder:
http://www.contextures.com/excelfiles.html#CH0003

or....if you want to store the pictures in the Excel workbook:
http://www.mcgimpsey.com/excel/lookuppics.html

or…for an alternative non-VBA solution, in case you don't want to use
programming:

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

Select Sheet2 and turn off Grid Lines
(ToolsOptionsView tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. InsertPicture 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:
InsertNameDefine
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:
InsertNameDefine
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.

Each time you select a different item in the list, the associated picture
will appear in the picture box and resize appropriately.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"Ray" <I ate wrote in message
...
I recently saw a pop music quiz using Excel. The photos of bands were in
the cells and the blank answer cell was beneath.
How can I put photos in a cell?
Thanks