is it possible to use the Not operator in Cases?
Im not sure, but you can use IS <> or IS < or IS >
e.g.
- dim a as string
-
a= "Option Two"
-
select case a
-
Case Is <> "Option One"
-
msgbox "Its not Option One, its " & a
-
case else
-
msgbox "Its Option One"
-
end select