Displaying embedded chart on userform
 

Several years back (1994), Microsoft showed a Histogram Wizard Demo add-in
on the VBA Solutions Development Kit CD-ROM. Chris Carvalho was listed as
the author. A snippet from that code is below:

Charts(GTempChart).ChartArea.Copy
GWiz5.Paste
'Get the name of the chart object on the dialog so we can refer
' to it later.
GWiz5ChartName = GWiz5.ChartObjects(GWiz5.ChartObjects.Count).Name
'Format the chart for preview display on the dialog.
With GWiz5.ChartObjects(GWiz5ChartName)
.Width = 170.25
.Height = 120
.Left = 80
.Top = 43
'more code to format the chart picture....
End with

Charts(GTempChart) would refer to your chart that you have built on a
worksheet or a separate chart sheet.
GWiz5 in the demo above referred to the 5th step of the user dialog box
(there were 5 steps, each with Back, Forward, Cancel, and Finish buttons).
Just substitute the variable name of your user form for GWiz5. Hopefully
this will give you a start. You might have to redo some of the methods, etc.
--
Regards,
Bill


"Bruce Forster" wrote in message
...
Is there any way to display an embedded chart on a userform.. I got the
chart to work and now I want it to display on a user form.
thanks

Displaying embedded chart on userform
 

See PastePicture.zip at http://www.bmsltd.ie/Excel/Default.htm



"Bill Renaud" wrote in message ...
Several years back (1994), Microsoft showed a Histogram Wizard Demo add-in
on the VBA Solutions Development Kit CD-ROM. Chris Carvalho was listed as
the author. A snippet from that code is below:

Charts(GTempChart).ChartArea.Copy
GWiz5.Paste
'Get the name of the chart object on the dialog so we can refer
' to it later.
GWiz5ChartName = GWiz5.ChartObjects(GWiz5.ChartObjects.Count).Name
'Format the chart for preview display on the dialog.
With GWiz5.ChartObjects(GWiz5ChartName)
.Width = 170.25
.Height = 120
.Left = 80
.Top = 43
'more code to format the chart picture....
End with

Charts(GTempChart) would refer to your chart that you have built on a
worksheet or a separate chart sheet.
GWiz5 in the demo above referred to the 5th step of the user dialog box
(there were 5 steps, each with Back, Forward, Cancel, and Finish buttons).
Just substitute the variable name of your user form for GWiz5. Hopefully
this will give you a start. You might have to redo some of the methods, etc.
--
Regards,
Bill


"Bruce Forster" wrote in message
...
Is there any way to display an embedded chart on a userform.. I got the
chart to work and now I want it to display on a user form.
thanks

Displaying embedded chart on userform
 

J-walk.com, has info on how to do this, go to the spread sheet page
and seacrh of charts on form, or some such, - you save as a .gif file,
if this is any use to you.