Charts and Userforms
Hi,
I don't think you need to use a userform. Try something like this....
Private Sub CommandButton1_Click()
Sheet1.ChartObjects(1).Copy
Me.Range("a2").Select
ActiveSheet.Paste
End Sub
This will paste the chart from sheet1 to the current sheet at A2....you
could add code to remove any chart which is already there...
Hth,
OJ
|