Cutting & Pasting JPGs to a userform in EXCEL 2010

[Walter349]

I have a requirement to create a user form for gathering data. However it also needs to be able to receive a jpg from another source. Directly linking to the source data is not permitted, so cut and paste is the way it is normally done on the existing spreadsheet in use.

Due to user inconsitancies in completing the spreadsheet accurately, it has been decided to create a data entry form to control the data being submitted.

Creation of the basic data userform is complete, only the coding remains.

Is it possible to insert to an object on the userform from the clipboard as I suggest, or am I chasing my tail here?

Any suggestions, code examples would be appreciated.

Thanks

'If at first you don't succeed, then your hammer is below specifications'

 

[UnsolvedCoding]

I am not aware of any way to place a picture on a user form.

 

[Andrzejek]

User can copy the image, open Paint, paste the picture, and save it. You may give the user a way to navigate to the location where jpg file is saved and show it in picture box or image box.

Have fun.

---- Andy