go to Stephen Bullen's site

http://www.bmsltd.ie/Excel/Default.htm

go down to the VBA section and get pastepicture.zip which addresses this
very requirement

http://www.bmsltd.ie/DLCount/DLCount...stePicture.zip

PastePicture.zip (9 April 1999, 34k, 13692 downloads) Updated - Saves a
chart or range as a bitmap or metafile
The userforms in Excel 97 are great, apart from one BIG letdown - you can't
put charts on them! A kludgy workaround has been to export the chart as a
gif or jpg, then load it into an Image control using LoadPicture. That
works ok-ish for charts, but it can't handle word art, shapes or other
pictures created on the fly. This file includes code to create a Picture
object from whatever is on the clipboard. Display a chart on a userform is
now as easy as a copy/paste. Thanks to VB MVPs Karl Peterson, Randy Birch
and Brad Martinez for their help. You can paste the image as either a
bitmap (better for same-size copies) or a metafile (better when
zooming/stretching), whichever best suits your circumstances. This update
includes an example of saving the picture to disk as a bitmap or metafile.

--
Regards,
Tom Ogilvy



"Swift2003 " wrote in message
...
hello there, i is in need of alittle wisdom from someone who knows. i've
got a couple of graphs on spreadsheets that i would like to be shown on
userforms. also the same with a section of data on a spreadsheet. any
ideas would be a start. ta


---
Message posted from http://www.ExcelForum.com/