Converting String to Control Name

[steven_b46]

I've got a control name written to an array as a string. Example:

mArr(25, 7)="ComboBoxD44"

Of course this is a combo box in cell d44.

What I'm trying to do is to reference this control and make changes (enable other controls, etc) based on its value if set to Yes, but if No or blank, disable controls and skip over processing any of the controls in the group.

How can I reference this as a control and not a string, so I can test its value such as :

if ComboBoxD44.Text="Yes" then...

[mikerickson]

On a userform, syntax like

Userform1.Controls("comboBox1").ListIndex = 2

is used. My Mac doesn't support ActiveX controls for the worksheet, but similar syntax probably exists.
If you are using controls from the Forms Menu, syntax like

ActiveSheet.Shapes("Drop Down 1").ControlFormat.ListIndex = 2

[steven_b46]

I get an error 438: Object doesn't support the property or method. This is the line that has the problem"

MsgBox ActiveSheet.Controls(mArr(f, 7)).Text

fyi, mArr(f,7) equals "ComboBoxD44"

WDYT?

[shg]

A worksheet doesn't have a Controls collection.

msgbox activesheet.oleobjects(mArr(f, 7)).object.text