can this code copy instead of move

**beatrice25** · 12-01-2008, 06:49 PM

Hi,
Can anybody assist me here pleeeease?
Can this code be modified to copy pictures rather than move them?
I want to keep them in a tidy library column A:A

The workbook finds a picture based on the picklist, it is an example I found online but I need it to copy and paste the picture (and leave the original where it is).

F1 cell
=VLOOKUP(A2, PicTable, 2, FALSE) this is connected to a 2 column validation table called picTable that has names in the first column (values in the picklist) and picture names in the second column (which corrosponds to the actual picture names)

Also, long after they have been copied, I need to clear all of what I have copied (with a macro button), but when I record a macro to do this it doesnt work because the copied "picture number' changes each time it is copied
and the recorded macro only deletes the picture object number that I deleted when recording it!

Please Login or Register  to view this content.

Thanks

Beatrice

**beatrice25** · 12-02-2008, 08:56 PM

Does anyone think this code can be modified or not?

**Simon Lloyd** · 12-03-2008, 12:14 PM

The code makes the picture visible, can you post a sample workbook?

**beatrice25** · 12-03-2008, 03:40 PM

Hi Simon,
i found this example online but it would be better if it showed a copy of the picture rather than the picture itself.
Once the picture is displayed I would prefer to manually delete it, therefore if I picked another picture from the picklist it would be ok if that went exactly on top of the one I had just picked

Also it would be nice if the original pictures could be remained in a single organised column (perhaps on another sheet) as a sort of library rather than hidden away.

I think this may all be too hard but if you can help I would appreciate it

Thanks

B