ComboBox BackColor change on value

[KennyA]

I have a ComboBox that I am trying to get the BackColor to change based on a selection.
There are 11 ComboBoxes on the sheet. After I have gone through all the boxes and made the selections
I hit the finish button which runs the VBA code.

Using ActiveX ComboBox. This is the code I tried using. I am obviously doing something wrong.
I want TERMINAL BOX to be green and NONE to be red

With ComboBox11
Select Case .Value
Case "TERMINAL BOX"
.BackColor = &HFF00&
Case "NONE"
.BackColor = &HFF&
Case Else
.BackColor = &HFF00&
End Select
End With

 

[Fluff]

How is it being populated?

 

[KennyA]

From the sheet. I used ListFillRange Q5:Q8. LinkedCell is L5

 

[Fluff]

In that case I don't see how the back colour would change if you used

With ComboBox11
    Select Case .Value
        Case "Yes"
        .BackColor = &HFF00&
        Case "No"
        .BackColor = &HFF&
        Case Else
        .BackColor = &HFF00&
    End Select
End With

if Yes and No are not one of the values in the combo.

 

[KennyA]

I was experimenting/troubleshooting and added Yes/No and set a different ListFillRange

 

[Fluff]

OK, because it's case sensitive, try

    With Me.ComboBox1
        Select Case LCase(.Value)
            Case "terminal box"
                .BackColor = &HFF00&
            Case "none"
                .BackColor = &HFF&
            Case Else
                .BackColor = &H80000005
        End Select
    End With

 

[KennyA]

I tried that code as well and still the BackColor did not change.
I am starting to wonder if this particular code set only works with YES or NO values

 

[KennyA]

I got it to work. I had to run the code on the sheet in VBA. Originally I was running it from a Module. Thank you for all your help!!!

With ComboBox11
Select Case .Value
'Case "YES"
'.BackColor = &HFF00&
Case "NONE"
.BackColor = &HFF&
Case Else
.BackColor = &HFF00&
End Select
End With

 

[Fluff]

Glad you got it sorted & thanks for the feedback