Hi Peter,

I am making a spreadsheet which is to be driven by userforms as I do not
want users to paste pictures into the sheets themselves, rather they would
paste them into a suitable box on a userform and then the user form would
enter the pasted image into the correct cell

To explain better, I use ChemDraw - a chemical drawing package - one usually
copies the structures in ChemDraw and you can paste them directly into Excel
- they appear as a floating selection in excel which can be dragged around,
resized etc.

I would like to paste the copied structure into a suitable dialog box on
userform which then deposits the picture into the correct cell of the
spreadsheet.

"Peter T" wrote:

Afraid I don't follow. You say "upload"; do you mean get/send an image from
a web site, or do you mean get an image from file and display on a sheet
(use Insert Picture method), or do you mean copied as an image from some
other app (manually or programmatically) and copied onto the sheet, or...?

Regards,
Peter

"Roger on Excel" wrote in message
...
Hi Peter,

Many thanks for posting your suggestion

I just read my post again and I dont think I described my problem very
well.

I am not needing to be able to create a picture on the form, but find a
suitable control which allows a user of the form in the spreadsheet to
paste
an image (or an image upload) which can be stored in the sheet and used in
the sheet.

For example I use the form for entering chemical data which is appended to
a
list in the sheet. This is fine, but I would like to paste in a chemical
structure from a ChemDraw drawing package into a form when i enter data.

I am guessing there must be an upload tool for a file such as a jpg or bit
map, but I really prefer to be able to paste in the individual image for
each
data entry.

I hope this explains better my requirements.

Regards,

Roger



"Peter T" wrote:

If you mean copy drawing objects onto a form, see Andy Pope's demo

http://andypope.info/vba/userformdraw.htm

Or for images you can load from file or other ways to an Image control

Regards,
Peter T


"Roger on Excel" wrote in
message
...
Is there a way to cut and paste pictures/objects into a userform field
such
that a user can paste in an external object (for example a chemical
structure
or a screen capture) into the form.

The pasted item in the userform would then need to be be appended to
the
spreadsheet at a chosen cell location and also pulled back to the
userform
when the user edits the userform (for example changes the embedded
picture).

I know how to do this with text (Contextures website) but would like to
learn how to do it with other objects.

Can anyone help?

Regards,

Roger


.



.