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

F

Fredrik

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

Bernard Liengme

JEMcG has a great solution but an alternative might be to use hyperlinks -
the picture will open in your default graphics viewer.
best wishes
 
R

Ron Coderre

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:
Insert>Name>Define
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:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT(Sheet1!$A$1)

8)Select cells A5:B10.
9)Hold down the [Shift] key and Edit>CopyPicture
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
 
Top