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").Value
What am I doing wrong ?