I'm wondering how I can check if a string contains either "value1" or "value2"? I tried this:
If strMyString.Contains("Something") Then
End if
This works, but this doesn't:
If strMyString.Contains("Something") or ("Something2") Then
End if
This gives me the error that conversion from string to Long can't be done.
If I put the or ("Something2")
inside the parenthesis of the first one, it gives me the error that the string cannot be converted to Boolean.
So how can I check if the string contains either "string1" or "string2" without having to write too much code?
You have to do it like this:
In addition to the answers already given it will be quicker if you use
OrElse
instead ofOr
because the second test is short circuited. This is especially true if you know that one string is more likely than the other in which case place this first: