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