Embeded picture in Excel

[Hintzcm]

I would like to embed a picture into a cell in Excel, so I can put a function
in a different cell and have it appear there. For example, if I were to
embed the picture in cell A1 in cell F43 I could type =A1 and the embeded
picture would appear in cell F43. If I copy and past the picture or insert
it through the image menu it just floats over the cell. I've read about
inserting it as a comment or a hyperlink, but that is not what I'm looking
for. I'm don't want to mouse-over or click on anything, I just want the
picture to be there. Any suggestions?

 

[Gord Dibben]

Pictures cannot be embedded in a cell and referenced by a formula like =A1

See John McGimpsey's site for one method using Event code, Data Validation
and VLOOKUP formula.

http://www.mcgimpsey.com/excel/lookuppics.html

OR go to Debra Dalgeish's site for a sample workbook from Bernie Dietrick
for adding pictures to selections.

Alows for more than one picture(or same picture multiple times) to be
displayed based upon a value or item chosen from DV lists

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection

Edit the code to suit.


Gord Dibben MS Excel MVP

 

[Jim]

Gord,

I've the John McGimpsey method. I've downloaded his sample sheet, played
with it, added more photos and names in the range and everything works.

However when I copy the exact source code (changed the range to the cell
where I want the photo) over to the sheet I need this function to work, it
does not. Instead of displaying the named picture, it displays the picture
name 'Picture 1' in the destination cell.

VBA is over my head, any help?

Thanks much in advance.

JIM

 

[Gord Dibben]

You copied the event code to another sheet but did you also copy the range
names and pictures to the other sheet?

John's code as written requires the pictures to be on the same sheet.

Also the range name PicTable must be defined properly for the list of
picture names associated with Picture1 through Picture??


Gord