userform help

[JasonLeVan]

I have a macro called chart it makes a chart of data in row a column a thru af. and it works great, but is there a way to make that data appear in a userform? like if i do a userform it will run that macro and put the data in the userform

 

[Rasm]

You want the chart to be displayed on the userform itself?

 

[Rasm]

If it is that data only - you could use a Listbox with multiple columns or a Lisview

 

[JasonLeVan]

yes thats what i am trying to do

You want the chart to be displayed on the userform itself?

 

[Rasm]

You can use MS Chart control - so look in the list of controls (right click on the toolbox and select additional controls) - but it really sucks - The Excel charts are much better. I am not sure if there is a better chart control available - maybe as a thirdpart OCX or control - but often they have problems - so if you use third party controls - be careful. When I try to paste a MS chart control onto a userform - I get not a trusted something - lol.

I suppose you could maybe copy the chart to the userform as a picture - just a thought - but now it is frozen so to speak.