You code would then only run from a single PC that has all the picture.
Another mthod is to put all the pictures into a workbook. Resize them
manually and put them ontop of each other. You can make one visiable and
make all the others invisible. then when you select the validation list move
the picurte you want to the top of the other picture and make it visible and
the others invisible.

"marc747" wrote:

Hi,

I have an excel file and in Cell "L21" I have a Validation list that
contains Picture names I want to see if I could place a Macro that
every time I select a picture name from the Validation list macro
would look into a folder (C:\Temp\Pix\) that contains all the pictures
(some .jpg, .gif. etc.) and insert it in cell "L10" and resize the
picture to Height 42 by keeping the Aspect Ratio. If no pictures were
found insert default picture called "NO Pic"

Thanks,
Marc
.