View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud[_2_] Bill Renaud[_2_] is offline
external usenet poster
 
Posts: 117
Default 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