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.

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.

Excel_ing for Greatness wrote:

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

You can place a picture in a Comment.

Right-click and Edit CommentSelect perimeter of Comment and right-clickFormat
CommentColors and LinesFillColor. In the dropdown select Fill
EffectsPicture.

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
wrote:

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.