Pictures in a worksheet

Z

ZorroZ

I have made a excel file with drop down list that have several product
too choose from in the list, what I would like too have is a drop dow
list that besides giving me the price (I us a formula like this
=IF(C4<>"";VLOOKUP(C4;$B$104:$C$1083;2;0);"") this gives me the price)
I would also like to get a picture of the product that is chosen in th
drop down list. Is this possible?

Thanks in advance!

Ki
 
R

Ron Coderre

For a non-VBA solution:

I'll assume you want to store the pictures on Sheet2 and show them on Sheet1.

1)Set the fill color for every cell on Sheet2 to White, then:
For each picture to be displayed:
1a. Insert>Picture from file. (select your picture and put it in the sheet).
1b. Select the range of cells that contains the picture and name it so it
includes the text that the dropdown will display:
Example:
Insert>Name>Define
Name: picFarming

2)Build your data validation list on a cell in Sheet1 and pick one of the
items.

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
....or whatever cell you chose.

4)Copy/Paste any one of the pictures from Sheet2 into the cell on Sheet1
where you want pictures to display.

5)While the picture is still selected, type this in the formula bar, then
press [Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the dropdown list.

Each time you select a different item in the list, the associated picture
will appear in the picture box and resize appropriately.

Is that something you can work with?

Ron
 
Top