Display Vendor Details And Picture on Product Selection

Hello,

hope this time i can get the help from excel experts.

here i m looking a VBA code to display vendor details and picture.

1) Product drop down list
2) Vendor details list box
3) Display Picture

please find the attached file

Hi MdYas,
You don't need vba for that, you can simply use the formula to do it also
for that copy a blank range past it as link object and create a name range and using the drop down and assing the name range to the link object
that will do it

Hi Siraj,

Thanks, have you seen my worksheet?

Dear Siraj,

will you please explain me in brief with a code.

Thanks in advance