pictures in comment boxes?

[Guest]

I would like to use Excel to organize inventory of office furniture and
equipment.
Ideally I would like to have a picture available when you hover over an
item. I was thinking that I could just drop a picture in the comment box but
that doesn't seem realistic. I am not well versed in excel and would
appreciate any feedback and suggestions.

 

[Dave Peterson]

If you decide that pictures in comments is a realistic approach, visit Debra
Dalgleish's site:
http://contextures.com/xlcomments02.html#Picture

You may want to hyperlink to a .jpg (or whatever), too.

 

[Gord Dibben]

You can place a picture in a Comment.

Right-click and Edit Comment>Select perimeter of Comment and right-click>Format
Comment>Colors and Lines>Fill>Color. In the dropdown select Fill
Effects>Picture.

For VBA code method to drop a picture into a Comment see Debra Dalgleish's site.

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

To have a picture show up when you select an item from a DV list see JE
MCGimpsey's site.

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

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

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

DV0049 - ClipArt Selection


Gord Dibben MS Excel MVP

On Wed, 13 Jun 2007 14:55:00 -0700, Excel_ing for Greatness <Excel_ing for