Picture based on cell content

Hi,

Sites down at the moment but when it's back up try

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

VBA Noob

Thanks - I tried the solution from that site a few days ago, but couldn't refer back to it as it was down. Based on what was on that site I had got this to work to an extent, but had given up on it in the hope of a better (easier to understand) method.

In this attached file I can get this to work if I only require one picture per sheet, but in this example I want to display 2 of them.

Can you give me any pointers on how I change the VB code to get it to work to get a different pic to display if I change the value in cell A14, as well as retaining the one called from cell A2, so.....

I change the name in cell A2 and get the pic for that, then change the name in cell A14 and get the pic for that one as well.

I know nothing at all about VB, so I'm struggling to understand it.

Someone has helped me out with this, so I thought I'd ppst the solution incase it is of use to anyone else. Code required is:

Please Login or Register  to view this content.

A picture won't be displayed if both cells are set to the same value.