Hiya

I wish to populate a listbox with all the chartobjects
within a workbook.

I am using something like the following

Dim xlChart as ChartObject

For each XlChart in Thisworkbook.Worksheets.ChartObjects

Me.ListBox.AddItem xlChart.Name

Next xlChart

Unfortunately it doesn't recognise the ChartObjects
collection.

Can any see a solution?

Thanks in a advance for any help

Nick Shinkins