Copying a chart to a user form

  • Thread starter samuel.dogbatse
  • Start date
S

samuel.dogbatse

Hello i am trying to copy a chart to a user form using :

Private Sub cmdagecharts_Click()
Dim chtchart As Chart
Dim image

Set chtchart = Sheet9.ChartObjects(1).Chart
image = chtchart.CopyPicture(xlScreen, xlPicture)
Set imgchtpic1.Picture = pastePicture(image)


End Sub

each time i run it this bit of code i get the error message Expected
Function or Variable

Your help is despirately needed
Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error message 1004 2
how to make chart on selected range? 1
Setting the Colour of Individual Items within a Legend 6
No Chart Titles 1
Chart Generation. Changing interior color. 3
Export to image ... way to get just cells without chart background? 3
opening up Powerpoint slide from Excel 2
Problem Copying Charts to PowerPoint 3

Top