add picture via drop down list

[s1ick]

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.

 

[JE McGimpsey]

One way:

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

 

[FSt1]

hi
not sure if this will help you out or not. not sure if this is what you what
but maybe, if nothing else, you can get some ideas.....
http://www.mcgimpsey.com/excel/lookuppics.html

regards
FSt1

 

[JB]

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/