Invalid use of property

[azizrasul]

Why do I get a compile error (Invalid use of property) on the RowSource line?

    With Sheets("Current")
        cboStartingLevel.RowSource "Current!CP_Level_Choice_Options"
        cboStartingLevel.ListIndex = Sheets("Current").Range("CP_Level_Choice") - 1

 

[Rick Rothstein]

Why do I get a compile error (Invalid use of property) on the RowSource line?

    With Sheets("Current")
        cboStartingLevel.RowSource "Current!CP_Level_Choice_Options"
        cboStartingLevel.ListIndex = Sheets("Current").Range("CP_Level_Choice") - 1

Is your ComboBox an ActiveX control located on a worksheet? If so, its property is ListFillRange not RowSource and you use an equal sign to assign a quoted address text string (or its equivalent) to it. Something like this...

cboStartingLevel.ListFillRange = "A1:A9"

 

[RoryA]

You're missing an = sign here:

cboStartingLevel.RowSource = "Current!CP_Level_Choice_Options"

 

[azizrasul]

The = sign did it, silly me. Thanks both.