Check to see if Chart Object Exist

[boldcode]

Hello,

I have a command button by the name "cmdTurn" that updates a chart when clicked. I want to create message box that checks the chart to see if a particular legend entry exists (e.g., "Profit"). If it does exist, it tells tells the user that this legend entry already exists therefore exit the sub. I wrote the following code, but I know its wrong:

My command button name is: cmdTurn
My chart object name is: chartTurn

Please Login or Register  to view this content.

I created a post already in Mr. Excel and here is the link: http://www.mrexcel.com/forum/microso...ect-exist.html

I just want to expand the network seeing that I have found no solution and to avoid the cross posting issue.

- BC

[Bernie Deitrick]

I think the best you can do is see what series already exist - but reading the legend key is not possible, IIRC.

Please Login or Register  to view this content.

[boldcode]

I get an error with method property "SeriesCollection," apparently Access does not like this property.

[Bernie Deitrick]

I think Access does - are you sure chartTurn is correctly declared as a chart object? You might actually have meant

Me.ChartObject("chartTurn")

Please Login or Register  to view this content.

[boldcode]

That's it, thanks for your help!

[Norie]

Cross-post.