Selecting Form Controls in Chart using VBA

Posted by Chris on November 06, 2001 7:26 AM

I have a chart with some Form controls placed on it - one of which is a drop down box (Dropdownbox15). The chart is on a sheet of its own (Chart2).

How can I select the dropdown box to manipulate it in Excel VBA?

I've tried:

Chart2.dropdownbox15.select

But it won't work - Can anyone help me!?

Posted by Dan on November 06, 2001 7:49 AM

Try this:

Charts("Chart2").Select
ActiveChart.Shapes("Dropdownbox15").Select

Of course, I always have to give the disclaimer that I'm not a VBA expert, so hope that helps.

Posted by Chris on November 06, 2001 8:14 AM

That worked fine. Thanks