Refer to a control inserted in chart

[Francisco Gomez]

I have inserted a checkBox in a chart. I need to refer to it programatically,
buy I must not use the control's name, because I plan to copy-paste the sheet
(chart is embedde on it) many times, and control (two checkboxes and one
command button) names change.

I have tried to search it by type (an later by 'caption' -it doesnt change
through copy-paste), in OLEObjects collection

For each obj in ActiveChart.OLEObjects

But ActiveCharts.OLEObjects is an empty collection for me.

Can you help me with this problem?

 

[Jim Cone]

Sub GetMeThere()
Dim obj As Shape
For Each obj In ActiveChart.Shapes
MsgBox obj.TextFrame.Characters.Caption 'or Text
Next
End Sub
--
No, it has never made a whole lot of sense to me either. <g>

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Francisco Gomez"
wrote in message
I have inserted a checkBox in a chart. I need to refer to it programatically,
buy I must not use the control's name, because I plan to copy-paste the sheet
(chart is embedde on it) many times, and control (two checkboxes and one
command button) names change.

I have tried to search it by type (an later by 'caption' -it doesnt change
through copy-paste), in OLEObjects collection

For each obj in ActiveChart.OLEObjects

But ActiveCharts.OLEObjects is an empty collection for me.

Can you help me with this problem?

 

[Francisco Gomez]

THANK YOU! (I never expected a checkbox to be a shape... )

 

[Dave Peterson]

Another way:

Dim CBX As CheckBox
For Each CBX In ActiveChart.CheckBoxes
MsgBox CBX.Caption
Next CBX