In Excel using URLs, how to display pictures stored on a server?
 

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.

In Excel using URLs, how to display pictures stored on a server?
 

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.