Code COMBOBOX value

[jakobt]

I have a form with an combobox called status with 3 values Completed, WIP or OPEN.
Is it possible to write a piece of code so if the value is completed the combobox turns green, if the value is WIP yellow and ind OPEN Green.

 

[Momentman]

Maybe something like this

Private Sub Status_Change()
    With Status
        Select Case Status.Value
            Case "Completed"
                .BackColor = vbGreen
            Case "WIP"
                .BackColor = vbYellow
            Case "Open"
                .BackColor = vbRed
        End Select
    End With
End Sub

 

[welshgasman]

I have a form with an combobox called status with 3 values Completed, WIP or OPEN.
Is it possible to write a piece of code so if the value is completed the combobox turns green, if the value is WIP yellow and ind OPEN Green.

If only 3, you could use Conditional Formatting as well.
More permutations could be added via VBA.