View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] samuel.dogbatse@gmail.com is offline
external usenet poster
 
Posts: 3
Default Copying a chart to a user form

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