Can't execute 'Or' Command???

Hi, I have the following code that activates an error message when C is not combined with 4/10,4/101,4/146 and 5/112.
However, it calling an error on these options and I can't see how. I realise I should have put this as a Case argument rather than or which leads me to the question. Is there a limitation as to
how many or commands I can have. Maybe, this is affecting things?

Private Sub ComboBox10_Change()

If ComboBox7.Text = "C" And ComboBox10.Text = "4/100" Or ComboBox10.Text = "4/101" Or ComboBox10.Text = "4/146" Or ComboBox10.Text = "5/112" Then
'Do nothing
Else
MsgBox "P.C.D. NOT OFFERED", vbOKOnly + vbExclamation, "INCORRECT"
End If

End Sub

Still won't work. It calls an error when the above options are chose. I really can't think why because I tested it earlier and it was fine?

It calls the message box error when I choose "C" combined with "4/146". Whereas, it is supposed to do nothing when they are chosen and to display an error when something
"other than" is selected. I'm at a loss, Lol

Do you think I got the "do nothing"command wrong, even though its in a comment

Here it is,

Check for leading/trailing spaces in your input.

I got the "do nothing"command wrong, even though its in a comment

How can you get a commented line wrong? It's ignored by the compiler.

Yeah, gimme 2 mins :-)

Changed the If statements to include brackets, but still having the problem

Changed the If statements to include brackets, but still having the problem

Have I corrected the statements accurately? Still no joy

'C SERIES HUB

    If ComboBox7.Text = "C" And (ComboBox10.Text = "4/100" Or ComboBox10.Text = "4/101" Or ComboBox10.Text = "4/146" Or ComboBox10.Text = "5/112") Then
        'Do nothing
    Else
        MsgBox "P.C.D. NOT OFFERED", vbOKOnly + vbExclamation, "INCORRECT"
    End If



'X SERIES HUB

    If ComboBox7.Text = "X" And (ComboBox10.Text = "4/139" Or ComboBox10.Text = "4/100" Or ComboBox10.Text = "5/112" Or ComboBox10.Text = "5/114") Then
        'Do nothing
    Else
        MsgBox "P.C.D. NOT OFFERED", vbOKOnly + vbExclamation, "INCORRECT"
    End If

You were right. If you add more hubs the code goes a bit nuts. Not sure why,

its on the 66 sq, I tend to copy to the others.

No, just the one of the two. I'll change it now, that may be the issue

I'll have another look

Got it working now, Thank you very much!!!!!!!