Hello,
1- Without VBA
-Assume products in column I and photo in column J
-Create names range with avec Insert/Name/Define
Product:=Offset($I$2,,,CountA($I:$I)-1)
Photo:=Offset($J$2,,,CountA($I:$I)-1)
Adr: =INDEX(Photo,Match($B$1,product,0))
-Select picture in B2:
-In formula bar: =Adr
-Valid with Enter
http://cjoint.com/?brkZ1rtRRz
2 With VA
http://cjoint.com/?brk0qEaJcJ
JB
http://boisgontierjacques.free.fr/
On 15 jan, 04:09, s1ick wrote:
I would like to use a dropdown list or a click box to add a specific picture
in my excel sheet. *So for example it I choose car form the list and picture
of a car appears and it I pick boat and picture of a boat appears. *I know
how to use and make dropdown lists and I know how to add pictures, but can’t
figure out how to combine these features. *