hendra
07-17-2008, 12:14 AM
Dear All ...
I have many charts on two separate worksheets in my original file.
Please open my simple excel file for illustration.
I have added VBA code to display all charts.
But I want to add one more combo-list so I can select particular charts(s) from many charts available.
Another question is, can you help me to modify my VBA code that can put all charts display on one "Chart1" sheet?
For your reference, please follow the helpful link below.
http://www.computorcompanion.com/LPMArticle.asp?ID=221
Sorry, I'm still green for VBA :think:
Thanks so much in advance.
Hendra
I have many charts on two separate worksheets in my original file.
Please open my simple excel file for illustration.
I have added VBA code to display all charts.
But I want to add one more combo-list so I can select particular charts(s) from many charts available.
Another question is, can you help me to modify my VBA code that can put all charts display on one "Chart1" sheet?
For your reference, please follow the helpful link below.
http://www.computorcompanion.com/LPMArticle.asp?ID=221
Sorry, I'm still green for VBA :think:
Thanks so much in advance.
Hendra