Userform that displays Charts

[PRodgers4284]

I have a userform that displays charts from a worksheet, the form has a next and previous option to view each chart, this works fine if all the charts are on the same worksheet. I need to use charts for various worksheets, how can i do this?

My code is:

Please Login or Register  to view this content.

[Andy Pope]

Currently the code uses a single index into a specific sheets chartobject collection.

You would need to maintain another counter that included the sheets as well.

Possible a better approach would be to loop through sheets and chartobjects and construct an collection.

Please Login or Register  to view this content.