Hi everubody,
Is there any userform control that we can paste a picture on it during
runtime. (right clcik paste) and then use that picture ( contenet) to insert
into our worksheet ...
I have doubt its possible ..
Thanks,
--
Best regards,
Edward

Quite a lot of API work is involved to extract a picture from the clipboard
and set it to the picture property of a control. Search "Stephen Bullen" and
"PastePicture" But why, if the objective is to place the picture on the
sheet why not paste it there directly in the normal way.

Regards,
Peter T

"Edward" wrote in message
...
Hi everubody,
Is there any userform control that we can paste a picture on it during
runtime. (right clcik paste) and then use that picture ( contenet) to
insert
into our worksheet ...
I have doubt its possible ..
Thanks,
--
Best regards,
Edward

Thanks, as I said I have doubt that this is possible but my question is not
about picture property of controls which is fairly easy to set . I wonder if
there is a contril that we can add to our userform and when lcick on it gets
the focus and when we right clcik it shows paste and we can paste our picture
on it and use this picture in our code ( lets sayd paste it in 100 worksheets
in a certain postion). Somthing that we can do with Word fields.
--
Best regards,
Edward


"Peter T" wrote:

Quite a lot of API work is involved to extract a picture from the clipboard
and set it to the picture property of a control. Search "Stephen Bullen" and
"PastePicture" But why, if the objective is to place the picture on the
sheet why not paste it there directly in the normal way.

Regards,
Peter T

"Edward" wrote in message
...
Hi everubody,
Is there any userform control that we can paste a picture on it during
runtime. (right clcik paste) and then use that picture ( contenet) to
insert
into our worksheet ...
I have doubt its possible ..
Thanks,
--
Best regards,
Edward

AFAIK none of the standard controls have such a feature, and I'm not aware
of any other controls that provide it either. As I mentioned the
functionality can be simulated if required, ie extract the picture from the
clipboard and assign to a control's picture property, initiated from a right
click.

Regards,
Peter T


"Edward" wrote in message
...
Thanks, as I said I have doubt that this is possible but my question is
not
about picture property of controls which is fairly easy to set . I wonder
if
there is a contril that we can add to our userform and when lcick on it
gets
the focus and when we right clcik it shows paste and we can paste our
picture
on it and use this picture in our code ( lets sayd paste it in 100
worksheets
in a certain postion). Somthing that we can do with Word fields.
--
Best regards,
Edward


"Peter T" wrote:

Quite a lot of API work is involved to extract a picture from the
clipboard
and set it to the picture property of a control. Search "Stephen Bullen"
and
"PastePicture" But why, if the objective is to place the picture on the
sheet why not paste it there directly in the normal way.

Regards,
Peter T

"Edward" wrote in message
...
Hi everubody,
Is there any userform control that we can paste a picture on it during
runtime. (right clcik paste) and then use that picture ( contenet) to
insert
into our worksheet ...
I have doubt its possible ..
Thanks,
--
Best regards,
Edward