pictures in comment boxes?

  • Thread starter Excel_ing for Greatness
  • Start date
E

Excel_ing for Greatness

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.
 
G

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
 
Top