Hello,
I am wondering what would be the cleanest way to accomplish the following string comparison task. I want to use an if statement to compare a single string to a group of strings, and output a message if true or do nothing if false. For example..
(I know the IN operator won't get this done in Excel, but I'd rather find something shorter than a bunch if IF ELSE)
IF "mystring" <> IN ("excel","is","cool")
THEN MsgBox "Error!"
END IF
Cheers!
Bookmarks