Insert picture in a comment

[lunker55]

Is it possible to insert a picture in the comments?
Everytime someone mouses over a comment, I would like the picture of the
model number in the cell to show.
Even better, I would like to put a formula in the comment to do a lookup in
a table and match with the cell and then show the picture.
I think creating a hyperlink for every cell will be too time consuming.
Or does anyone have any other ideas?

Joe

 

[Frank Kabel]

Hi Joe
AFAIK it is not possible to include formulas or pictures in this
comment field. so you would have to develop this kind of shape on your
own. I would use a hyperlink to your file in an adjacent cell using the
HYPERLINK formula. Example: If you have named your pictures like the
model number use a formula like
=HYPERLINK("C:\temp\pictures\" & A1 & ".jpg",A1)

 

[Debra Dalgleish]

There are instructions here for adding a picture to a comment:

http://www.contextures.com/xlcomments02.html#Picture

 

[Frank Kabel]

Hi Debra
as always I'm impressed by your ideas
Thought iserting pictures wouldn't be possible.
Regards
Frank