ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   charting in VBE (https://www.excelbanter.com/charts-charting-excel/123502-charting-vbe.html)

shnim1

charting in VBE
 
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

charting in VBE
 
Hi,

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

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

Cheers
Andy

shnim1 wrote:
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






All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com