/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

0 vote337 views1 answer
Excel vba formatconditions positive
VBA
15 votes478 views1 answer
Excel vba wait
VBA
0 vote349 views1 answer
Vb ternary
VBA
0 vote357 views1 answer
Vba excel parser xml
VBA
0 vote329 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote322 views1 answer
Vba sheet visible
VBA
1 vote336 views1 answer
How to check is the value enterd is a number or text in vba
VBA
5 votes382 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote346 views1 answer
Xlbycolumns is not declared
VBA
3 votes352 views1 answer
Vba http request json
VBA