Graphics in a Cell Comment

[cbs]

Hello,

Recently, a question was posed in this NG (I think) about inserting a
graphic into an Excel cell comment. I have lost track of the original
thread.

This is how it can be done (apologies if this has already been covered):

1. Select a cell, right click, select Insert a Comment.
2. Hover your cursor over the cell border until it turns into a four-headed
arrow. Right click, select Format Comment.
3. Select the Colors and Line tab.
4. Click the Fill Color drop down menu and select Fill Effects.
5. Select the Picture tab.
6. Click Select Picture.
7. Go to the directory that holds your graphics/pictures. Select the
graphic/picture that you want displayed. Click OK, OK, OK.

Resize the Comment box to fit the graphic.

You can also insert text that overlays the graphic. Select the commented
cell, right click, Edit Text, start typing. Have fun with changing the
standard shape of a Comment box (View Menu / Toolbars /Drawing/ Draw/
Change AutoShape).

The above procedure can be followed to insert a graphic into an Excel Text
Box or Auto Shape.

Copy an Excel chart to PowerPoint, resize if required, then Save As to a
GIF or JPEG format. Insert the Chart into a Comment.

Regards,

Mike
Perth, Australia

[John Walkenbach]

Thanks for the great tip, Mike. It had never occured to me that a cell
comment can display a graphic image.

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss

"cbs" <c...@vianet.net.au> wrote in message
news:01c22373$4edcce60$454ea5ca@laptop...

[Max]

Great tip ! Thanks, Mike. cheers.

>.
>

[tecsiy...@gmail.com]

Hi

I have a slightly more complicated request. I want to display a student's picture in the comment box accompanying their student numbers.

The pictures are all the same size and type. Picture file names are the same as student's student number.

I know zillltch about programming, VBA etc.

Pictures in a source folder - or can these pictures also be embedded in the Excel workbook. In this case we are talking about 99 students.

Please assist. Much much appreciated.

Andries

[Gord Dibben]

Debra Dalgleish covers this request with code and a sample workbook.

http://www.contextures.on.ca/xlcomments03.html#PictureFile

List of pictures in a column with a Comment and picture.

Suggest you re-size pictures before importing them to sheet.


Gord


On Sun, 19 Jan 2014 01:29:25 -0800 (PST), tecsiy...@gmail.com
wrote: