VLOOKUP and pictures ?

[dirty_cofi]

hey,

for a project i am going a order form in excell and i want it so if they select the product name in the drop down list that excel then will return a picture of that item via VLOOKUP.

The problem seams to be that pictures don't have a cell reference so VLOOKUP can't be used, so any ideas please.

Thanks

 

[Chris Davison]

http://www.mrexcel.com/board/viewtopic.php?topic=1773&forum=2

this is nearly the same, maybe you can tailor it to suit your needs ?

 

[dirty_cofi]

Thz i think i can get it to work now, i'll hav to brush up on my coding

later