Pictures in a worksheet
 

I have made a excel file with drop down list that have several products
too choose from in the list, what I would like too have is a drop down
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 the
drop down list. Is this possible?

Thanks in advance!

Kim


--
ZorroZ
------------------------------------------------------------------------
ZorroZ's Profile: http://www.excelforum.com/member.php...o&userid=22825
View this thread: http://www.excelforum.com/showthread...hreadid=378332

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

--
Regards,

Peo Sjoblom

(No private emails please)


"ZorroZ" wrote in
message ...

I have made a excel file with drop down list that have several products
too choose from in the list, what I would like too have is a drop down
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 the
drop down list. Is this possible?

Thanks in advance!

Kim


--
ZorroZ
------------------------------------------------------------------------
ZorroZ's Profile:
http://www.excelforum.com/member.php...o&userid=22825
View this thread: http://www.excelforum.com/showthread...hreadid=378332

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. InsertPicture 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:
InsertNameDefine
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:
InsertNameDefine
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

That looked like something I can use, yes! Thanks a lot!

Kim


--
ZorroZ
------------------------------------------------------------------------
ZorroZ's Profile: http://www.excelforum.com/member.php...o&userid=22825
View this thread: http://www.excelforum.com/showthread...hreadid=378332