Select case using NOT operator (97)

Topic

New Reply

Select case using NOT operator
I

Reply | Quote

Replies

The correct syntax would be:

Case Is  "Dir", Is  "Mgr", Is  "Coord"

But I don’t think that’s what you want, because ANY string evaluated will equate to true, including “Dir”, etc. Shouldn’t it be AND separating the items, not OR?? You may try this instead:

If strA  "Dir" And strA  "Mgr" And strA  "Coord" Then
    MsgBox "True.", vbInformation, "TRUE"
Else
    MsgBox "False.", vbInformation, "FALSE"
End If

Replace “strA” with your string variable to test this.

HTH

Reply | Quote

Yes that was more along the lines of what I was looking for, thanks.

Reply | Quote