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

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

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


.

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


.

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


.



.

I'm still not following

" they appear as a floating selection in excel which can be dragged around"

What is that "floating selection", some sort of object no doubt but what, a
Picture? How did it get in the clipboard (from your code or by user
mouse/keyboard copy), is it an image in the clipboard. Do you want the image
to go straight from clipboard onto the userform (and what do you mean by
into a dialog), or from the floating whatever it is on the sheet then into
the something (dialog?) on the userform.

Regards,
Peter T



"Roger on Excel" wrote in message
...
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


.



.