charting in VBE

[shnim1]

Hi

I heard that it was possible to add charts to VBA userforms (through
active X controls). Does anybody know of a good source to get templates
from and the code to drive the data????

If it cannot be done, let me know if someone is pulling my leg ;->

PEACE

 

[Andy Pope]

Hi,

Maybe they were referring to the OWC (Office Web Component).
http://www.excelkb.com/article.aspx?id=10189&query=owc+chart

The example says VB6 but you should be able to adapt for VBA.

Cheers
Andy