You cannot insert a picture into a cell, only on top of the cell.
Just InsertPictureFrom File to wherever you want it.
Alternatives to the above.................
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
As written John's code allows for only one picture to be displayed.
Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for
adding pictures to selections.
Alows for more than one picture to be displayed.
http://www.contextures.on.ca/excelfiles.html#DataVal
DV0049 - ClipArt Selection
Gord Dibben MS Excel MVP
On Mon, 20 Aug 2007 14:12:08 -0700, jwpowers
wrote:
For Excel 2003 SP2:
I want to prepare an Excel report where the output rows have a photo and
it's description. In each row, 1 cell is for the description, the next is the
photo and the 3rd is for another person's comments about the photos on each
row.