Hello,

in sheet1

contain customer name & i create a list of customer name

a1 cell contain list

now ,

i select name of customer in list, photo of customer is shwon in b1 cell

please vba help or macro for this