vba syntax for multiple OR's

[mainerain]

This works for me...

Sub Check1()        If strCheck1 = "C-5" Then
            strMachine = strCheck1
        ElseIf strCheck1 = "C-6" Then
            strMachine = strCheck1
        ElseIf strCheck1 = "C-7" Then
            strMachine = strCheck1
        ElseIf strCheck1 = "C-8" Then
            strMachine = strCheck1
        Else
            strMachine = Null
        End If
End Sub

but why can't i put multiple OR's on one line? like this:

Sub Check1()
        If strCheck1 = "C-5" or "C-6" or "C-7" or "C-8" Then
            strMachine = strCheck1
        Else
            strMachine = Null
        End If
End Sub

[pbaldy]

You have to repeat the field:

If strCheck1 = "C-5" or strCheck1 "C-6" ...

[mainerain]

I see.... Thanks

[pbaldy]

No problem. Hopefully you saw my missing =. Should be:

If strCheck1 = "C-5" or strCheck1 = "C-6" ...