I have looked a many, many forums and posts to find out how to do this. I have gleaned enough information to take me to a certain point but now I am at an impasse.
I have written a macro that will copy a picture into a shape on a worksheet sized as I wish. If I select and copy the shape to the clipboard (Ctrl-C) and then paste (Ctrl-V) into Userform.Image.Picture properties in the VBA editor the picture (presumably as a shape) is inserted into the image control and zoomed so as to fit. All that is great (since it is not a link to an external image any longer but is now "stored" in the excel workbook file).
The problem is that I want to do this through VBA, not through keystrokes.
Where I get stuck is "pasting" the clipboard data into the image control properties box and I can find no coherent information on how to do that.
My understanding is that once an image is inserted into a shape, it is assigned a new name by excel. Can I retrieve the name and code that into Image.Picture properties?
Is there a way assign a variable to the clipboard data (presumably the shape with the image inserted) that can be used as an "Image1.Picture=variable" line of code? If so, how so?
The whole key here so as not to rehash a great deal of Q/A is to have the image in the document so pictures (source files) can be deleted or moved with affecting the excel doc.

DJams