Hi!

I have a dropdown list in an EXCEL worksheet. Based on what is
selected in the dropdown list, I want to display a picture within a
cell or cells in the same worksheet. The pictures are in a location on
my hard drive. I want this sheet to be used by another user, so I guess
I just cant give it a path on my computer for the display method. I
want to store the pictures within the workbook (on a separate
worksheet) and then be able to display them in the sheet which has my
dropdown list whenever an item is selected from it. Also, whenever the
selection in the dropdown list is changed I want the previous picture
to be erased and replaced with the new selection's picture.

I'd appreciate any help as to how to code this.. or if there is a
canned code somewhere...
Please let me know if you have any questions...

R