Insert a picture in the COMMENT window

[DraftThe3Car]

I know how to right click on a cell and then click INSERT COMMENT.

Does anyone know if it is possible to insert a jpg in to that comment window? This will be perfect for my product presentation.

 

[Juan Pablo González]

Make sure that the comment is selected, that you can NOT edit the text, in other words, there SHOULD NOT appear any blinking cursor in the comment. Then, use the Fill properties as told before.

 

[Barry Katcher]

Thanks, Juan Pablo, your method is great!

 

[klb]

Double Click on the comment and then make sure you right click on the border of the comment to bring up the Format Comment menu

 

[Barry Katcher]

Draft, you're not crazy. Sometimes when I right-click on the comment border, I only get a Copy-Paste-Move box, other times I get the whole ball of wax, including Format Comment. Doesn't seem to be any rhyme or reason to it. Just keep clicking until you get it. You might want to set up a macro to repeatedly move your finger on the mouse.

 

[smittycft99]

That's slick, niiiiccceee!

Draft , don't right click on comment, just double click on border of comment.

 

[GeorgeB]

The whole routine for those who didn't get it.

1. Right click on the cell with the comment.
2. Hover the pointer on the border of the comment. When it changes to a four sided arrow right click.
3. Select Format Comment
4. Select the Colors and Lines tab
5. Select Color (Drop down box)
6. At the bottom of the drop down box select Fill Effects
7. Select the Picture tab
8. Press the Select a Picture button
9. It will open you’re My Pictures file
10. Highlight a picture
11. Press Insert
12. Press OK and OK again.
13. Voila

 

[DBA]

G'day all,

When you right click on the comment box, make sure you click on the frame of the box and not inside it, otherwise Excel thinks you want to edit the format of the font and not the comment itself.

Regards,

DBA

 

[Ivan F Moala]

Have a look @ this thread where Chris
has a List of Formula1 drivers that he
updates via Data validation, coupled with
the sheet change event to display the Drivers picture.

http://www.mrexcel.com/board/viewtopic.php?topic=1773&forum=2

 

[Barry Katcher]

Hey, guys, I've been playing with this. You can insert pictures into Autoshapes and Textboxes as well. In a textbox, you can also add and format text, which overlays the picture. Cool.

 

[drag-driver]

Just to make life complicated dont know if its possible but can a graph be inserted instead of a picture, or is their any way that the properties of a coment be passed on to grph such as you click on a cell and a graph apears.