Error 380

[azizrasul]

I have a form upon which is a combo box. When I initialise the form, I have the following line

cboShow_CP.ListIndex = Sheets("Current").Range("Show_CP_Prem_Choice") - 1

I get the error "Could not set the ListIndex property, Invalid Property Value.

The value I get for Sheets("Current").Range("Show_CP_Prem_Choice") is 2. Sheets("Current").Range("Show_CP_Prem_Choice") are the following values i.e. Yes, No and Modular.

AG
10 Yes
11 No
12 Modular

 

[azizrasul]

When I hover over

cboShow_CP.ListIndex

I get -1.

The BoundColumn is 1, the ColumnCount is also 1, the RowSource is Show_CP_Prem a named range given above with the 3 values.