I have 5 different pictures I want to link cells. For instance I want a cell
to hold values 1,2,3,4, or 5. Based on this cells value, I want it to
display a particular picture. I haven't been able to paste the picture as
data inside a cell. The pictures only become objects on top of the
worksheet. Any ideas?

You cannot insert or paste an object into a cell, only on top of the cell.

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

Your needs seem to be exactly what John's sample workbook does. One picture at
a time based upon the value in a cell.

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 Mon, 5 Nov 2007 13:57:02 -0800, cna48
wrote:

I have 5 different pictures I want to link cells. For instance I want a cell
to hold values 1,2,3,4, or 5. Based on this cells value, I want it to
display a particular picture. I haven't been able to paste the picture as
data inside a cell. The pictures only become objects on top of the
worksheet. Any ideas?