How to list properties of a chart object in VBA?

问题:

I want to clone(using VBA) some charts and be able to change them for that I need to know what they contain.

How to list properties of a chart object in VBA, more like an object dump in other languages?

回答1:

In the VBE, use the Locals window:

You can then copy any existing charts, and simply manipulate the properties that need to be changed for each, or you can create new charts on-the-fly, setting the properties as needed.