How do I import named pictures into corresponding cells in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have photographs in a file I would like to import into an address file. Is
there a way this can be done?
 
You cannot insert a picture into a cell, only on top of the cell.

Just Insert>Picture>From 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
 
Back
Top