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
|