excelvba Imitating the "IN" operator from python code example
Example: excel vba Imitating the "IN" operator from python
'VBA does not have an IN operator, but we can do this:
Function IsIn(a, b) As Boolean
IsIn = InStr("," & b & ",", "," & a & ",")
End Function
'--------------------------------------------------------------------
MsgBox IsIn(2, "1,2,3") '<-- displays True
MsgBox IsIn("d", "a,b,c") '<-- displays False