Chart in a Userform

M

mklo

Joined
Apr 8, 2006
Messages
2
Reaction score
0
Hi!!

How can I embed a chart that is place in a new sheet in a Userform? I now how to do it if the chart is in an existing sheet,

Set CurrentChart = Sheets("Chart1").ChartObjects(1).Chart
CurrentChart.Parent.Width = Width
CurrentChart.Parent.Height = Height

fname = ThisWorkbook.Path & Application.PathSeparator & "temp.gif"
CurrentChart.Export FileName:=fname, FilterName:="GIF"

imgChart.Picture = LoadPicture(fname)


but this is not what I need... Can someone help me??

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

Image on userform from picture in a worksheet 2
paste 2 charts on the same image on a userform 2
Charts in VBA 0
dynamic chart range with VBA 6
Remove Picture from Image1 on a Userform 1
Chart into Userform Problem 7
Chart Picture Size in UserForm/Picture Control. 8
How can I change size of the picture without changing chartobject? 6

Top