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 label exists (e.g., "Profit") then it tells the user that this legend label already exists therefore exit the sub. I'm thinking something like this:

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

[CODE]If Me.chartTurn.Legend.("Profit") = true
MsgBox ("The Profit legend label already exists,")
then
Exit Sub
Else
execute cmdTurn VBA code I had already wrote
End Sub

-BC

 

[Norie]

What do you mean by a legend 'label'?

The legend of a chart has LegendEntries, is it perhaps a legend 'entry' you want to check for?

 

[boldcode]

Yes, sorry a Legend Entry

 

[Norie]

You could use something like this to loop through the legend entries of a legend but I can't find out a way to get the name, or text, of the legend entries.

If Me.chartTurn.HasLegend Then
    For Each lgdent In Me.chartTurn.Legend.LegendEntries
        
    Next lgdent
End If

 

[boldcode]

I can't figure it out either

 

[boldcode]

Hi Norie, Bernie Deitrick, from Excel Forum solved this post for me. Here is the link to the post:

Check to see if Chart Object Exist

Thanks for all your help Norie.

- BC

 

[Micron]

boldcode, when you cross-post, it is proper etiquette to post a link to the other site(s) so us volunteers don't waste time working on something that may have been solved elsewhere. It allows us to check and not suggest things that were already suggested somewhere else. It's actually better to wait awhile to see if you get a solution before posting your question a second time somewhere else. The moderator here might have more advice or suggestions if this comes to their attention - I'm not sure if there's anything else I should have mentioned.