Hi Andy,
Thanks very much ... working perfectly.
Cheers,
Loane

"Andy Pope" wrote in message
...
Hi Loane,

Check out Stephen Bullen's PastePicture example, it requires some quite
complex code and API usage.
(http://www.bmsltd.ie/Excel/Default.htm)

Or a maybe an alternative approach, especially if you are after placing
a chart on a userform, from John Walkenbach.
(http://www.j-walk.com/ss/excel/tips/tip66.htm)

Cheers
Andy

Loane Sharp wrote:
Hi there.

In code, can I load a bitmap into an image control from the clipboard?

I've stored the bitmap onto the clipboard in code as follows:

ActiveSheet.ChartObjects("Chart 1").CopyPicture xlScreen, xlBitmap

Normally, I would load a bitmap from a file as follows:

UserForm1.Image1.Picture = LoadPicture(pathname).

Can anyone help?
Thanks,
Loane






--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info