Hi Joel,
Thanks for the quick replay.
But my problem is that I use shared Excel, hence I cant paste an image into
the sheet. Therefore I want to use a UserForm which I could paste the image
into.
So I use the statement Worksheets("data").Range("b1:d3").CopyPicture
xlScreen, xlBitmap to copy a area of the sheet as a bitmap into clipboard,
and then I want to paste it into a userform. It is that pasting which does
not work. I have tried for hours; search the net, but without any success.
Your proposal works very well if my workbook is not shared.
BR,
Gaia
"Joel" wrote:
Worksheets("data").Range("b1:d3").CopyPicture xlScreen, xlBitmap
Range("K6").Select
ActiveSheet.Paste
"Gaia" wrote:
Hi,
Is there anybody out there who could help me with pasting a picture from
ClipBoard into a VB form in Excel? I use excel 2003.
The function for copying a range is working; I use:
Worksheets("data").Range("b1:d3").CopyPicture xlScreen, xlBitmap
I have a form defined, but whatever I try, I cant paste it into a form.
Anybody who could give me a hint?