CODEWITHSUNDEEP
excelvbacharts
Eduard Florinescu
Eduard Florinescu

Reputation: 17511

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?

Upvotes: 1

Views: 8201

Answers (1)

David Zemens
David Zemens

Reputation: 53623

In the VBE, use the Locals window:

Screenshot of partial view of Locals window for Chart

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.

Upvotes: 2

Related Questions