View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Cut and paste objects into userforms

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