View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Picture displayed when item selected in a different cell

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

JB Bates wrote:

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