I have a combo box on my Excel User form (called coCategory) and, depending on the value in another form field (coStatus), I want to change the colour of the text.
Here's my current code which doesn't work !!
If Me.Controls("coStatus").Value <> "Completed" Then
coCategory.Font.Color = vbRed
What do I need to correct to get it to work ?