An alternative from Stephen Bullen that copies the chart and places the
contents into an image control in bitmap or metafile format:
"The userforms in Excel 97 are great, apart from one BIG letdown - you can't
put charts on them!"
http://oaltd.co.uk/DLCount/DLCount.a...stePicture.zip
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
wrote in message
...
On Mar 26, 4:48 am, JudgeMental
wrote:
I would like to runa macro that creats a chart, then show the chart in a
form.
Can that be done?
You can save a pre created chart as picture and use that on a form,
all through a macro. Visit John Walkenbach's
http://j-walk.com/ss/excel/tips/tip66.htm
page for more details.
Anant