Is it possible to attach a clipart or picture into a cell?
 

Is it possible to attach a clipart or picture into a cell?

For example I want to use it like this

If I type a article number into cell A1, I want to have a picture of it in
cell A2 and the picture exist already in a excel library.

Cells can contain only values or formulae. Pictures exist in the Drawing
Layer "on top of" the cells. However, you can position a picture to
cover a cell, and move/resize with the cell.

Take a look here for one suggestion:

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



In article ,
"Fredrik" wrote:

Is it possible to attach a clipart or picture into a cell?

For example I want to use it like this

If I type a article number into cell A1, I want to have a picture of it in
cell A2 and the picture exist already in a excel library.

JEMcG has a great solution but an alternative might be to use hyperlinks -
the picture will open in your default graphics viewer.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Fredrik" wrote in message
...
Is it possible to attach a clipart or picture into a cell?

For example I want to use it like this

If I type a article number into cell A1, I want to have a picture of it in
cell A2 and the picture exist already in a excel library.

A possible non-VBA solution:

I'll assume you want the pictures to show on Sheet1.

1)Paste a picture into a blank sheet in your workbook.
2)Select the range of cells that contains the picture,
3)Set the fill color of the range to White.
4)Name that range of cells:
Example:
InsertNameDefine
Name: rngArticle100

5)Repeat steps 1 thru 4 for each picture (making sure that no picture ranges
overlap)

6)Select Sheet1 and type one of your picture range names in Cell A1.
7)Create a dynamic range name as follows:
InsertNameDefine
Name: ShowMyPic
RefersTo: =INDIRECT(Sheet1!$A$1)

8)Select cells A5:B10.
9)Hold down the [Shift] key and EditCopyPicture
10)Paste the picture somewhere over Cell E10.
11)While the picture is still selected, type this in the formula bar:
=ShowMyPic
and press [Enter]

The range of cells that was previously displayed should now be replaced by
the picture referred to by the name you typed in Cell A1.

Each time you type a different picture range name in Cell A1 the associated
picture will appear in the picture box and resize appropriately.

Also, you could reference a list of those picture range names in a Data
Validation so you could simply pick them from the list.

Is that something you can work with?

Regards,
Ron