Picture appear when certain drop down list info selected.

[leaper1981]

Hi,

Just wondering if anyone can help at all. I have a sheet with a drop down list & another sheet with pictures that relate to each of the options in the drop down list on the main sheet. I want the pictures to appear in a box next to the drop down list when a certain one is selected. I did see a tutorial but it seemed to have the pictures on the same sheet whereas I want to keep the pictures on a different sheet. Not sure if I've done a good enough job of explaining here but I'm sure its very simple for someone that understands this better. Any help would be great. I've included pictures, the drop down list is on the main document shhet & the pictures are on a separate 'data' sheet.......im calling it.

Thanks in advance.

Dan

 

[leaper1981]

Nope just realised that link requires you to sign in to my google account, sorry for being stupid I've got it in the google drive I'm not sure how to give it to you

 

[kevin9999]

You need to make the file available to "Anyone with the link" then copy the link to here. See this.

 

[leaper1981]

aha! I think I've done it now - PCI SR.xlsm

 

[kevin9999]

Got it now - leave it with me, I'll look at this tomorrow.

 

[leaper1981]

Thanks Kevin, sorry for being so useless, I really appreciate your help.

 

[leaper1981]

Hi Kevin,

That's brilliant thanks. I sent it without any of the code as I didn't want my messing to confuse the situation, This is doing exactly as I wanted, I know there's pictures missing etc, I wasn't expecting you to do it all for me, I just needed that push as you say lol. I'm very sorry for being a bit useless with this I really appreciate all your time, effort and help.

Thank you again.

Dan

 

[kevin9999]

You're welcome Dan, and thanks for the feedback