View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JB JB is offline
external usenet poster
 
Posts: 115
Default add picture via drop down list

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. *