Tocogroup
asked on
How do I reference an Excel VBA ActiveX control ?
Hi All,
I have an Excel sheet with an ActiveX combo box named coYear. However, when I try to refer to it in my VBA procedure I get the following error message : Compile error. Method or data member not found
I'm trying to load a variable called strFileNameYear from this control object as follows:
strFileNameYear = Me.Controls("coYear").Valu e
What am I doing wrong ?
Thanks
Toco
I have an Excel sheet with an ActiveX combo box named coYear. However, when I try to refer to it in my VBA procedure I get the following error message : Compile error. Method or data member not found
I'm trying to load a variable called strFileNameYear from this control object as follows:
strFileNameYear = Me.Controls("coYear").Valu
What am I doing wrong ?
Thanks
Toco
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER