Picture displayed when item selected in a different cell

[JB Bates]

Hi

I have tried
http://www.mcgimpsey.com/excel/lookuppics.html
But that only allows for ONE picture to be displayed per page.

I also tried
http://www.contextures.on.ca/excelfiles.html#DataVal
but my Source and Results cells are both sets of merged cells and this
unmerges both the source and results cells.

What I am trying to accomplish is when a person's initials are selected from
a drop down list in cell A1 (which is actually merged A1:B1) i want the
person's signature, saved as an image file, to appear in D1 (which is
actually merged D1:F1). There is a list of 10 rows on each worksheet that
has the ability to associate a signature to a person's initials. So I need
the ability to have various images display multiple times on one worksheet.

ANY help on this would be greatly appreciated. I am at a loss and don't
know how to resolve this.

THanks in advance for time and assistance - Jennifer

 

[Bob I]

Please understand that the images are not actually in the cell but only
overlaid on the sheet.

 

[Gord Dibben]

Why are you posting this when you have thread already running on same
subject?


Gord Dibben MS Excel MVP