Copy Picture from one worksheet to Another using Macros

[falkon007]

Hi Experts

I am a long time browser but very new poster.

I am trying to add functionality to an excel workbook which shows a picture of a users signature.

So I have a drop down list with the various users who are inputting the data for the particular flight (its a flight planning tool, irrelevant to the problem) using data validation.

What I am trying to achieve is to show the image of their signatures (which I have scanned in to the excel document on another worksheet called "Raw Data") when they select their names from the drop down list.

So if i could create a macro code that goes something like:

Please Login or Register  to view this content.

SO basically I I want to write code that shows if cell L3 (the drop down menu) shows the name SMITH in there, then copy the picture (that I named SMITH) from the Raw Data worksheet to the same location as cell P3 in the PLAN worksheet.

I can change this to a CASE or write multiple IF statements but I am failing to get the basics up and running so I can tweak and improve the code.

(My Next problem will be how to make the previous signature disappear when a new name is selected from the drop down list.)

Thank you so much for any help you could provide.

Cheers

[falkon007]

OK after continuing to guess and have a go I came up with something that works:

Please Login or Register  to view this content.

However when a new name is selected and the macro re-run all it does is paste over the old picture. How can I delete a picture (if one exists) and then run the "IF" checks and paste the new correct picture?

(I need code that translate between excel 2003 and 2007).