Hi there,

I have a userform, but a'm having some trouble with some lines of VBA.
I have two Comboboxes (1 and 2).
The options in combobox 2 are: (Open; Transfered; Pending; Closed)
I need that when combobox 1 is not empty and the 2nd combobox is filled with something other then "Closed" a message box appears telling the user to change combobox 2 to "Close". This should only happens when combobox 1 is filled.

I'm using this code but it's not working. I get the message box but it happens even when cbo1 is filled and cbo2 has is filled with "Closed"

"    If Trim(Me.cbo1.Value) = ""Serviço Jurídico"" Or (Me.cbo1.Value) = ""Serviço Tesouraria"" Or (Me.cbo1.Value) = ""Serviço Contabilidade"" Or (Me.cbo1.Value) = ""Provedor do Cliente"" Or (Me.cbo1.Value) = ""Serviço Clientes"" Or (Me.cbo1.Value) = ""DRR"" And (Me.cbo2.Value) = ""Open"" Or (Me.cbo2.Value) = ""Transfered"" Or (Me.cbo2.Value) = ""Pending"" Or (Me.cbo2.Value) = """" Then
    Me.cbo1.SetFocus
    MsgBox ""Change 2nd Combox to Closed."", vbExclamation, ""Informação em Falta""
    Exit Sub
     End If"