/VBA/Excel vba Imitating the "IN" operator from python

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

Source: academy.excelhero.com

Similar codes

1 vote131 views2 answers
Vba function return array
VBA
3 votes182 views2 answers
Excel "vba" match last value
VBA
1 vote137 views1 answer
Excel vba close form escape key
VBA
2 votes146 views1 answer
Excel vba check if string entirely alpha
VBA
1 vote136 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote148 views1 answer
Vbs run with cscript
VBA
1 vote123 views1 answer
Vba compile error object required
VBA
1 vote130 views1 answer
Excel vba hide zero values
VBA
0 vote147 views1 answer
Power query M substract minimum value of column -dax
VBA
1 vote131 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA