/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 vote178 views1 answer
Find database connection string vb
VBA
0 vote175 views1 answer
Vba integer to double
VBA
0 vote168 views1 answer
Make your computer talk vbscript
VBA
0 vote177 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
0 vote176 views4 answers
Jwt token vb.net validation
VBA
0 vote204 views1 answer
Winforms dark title bar
VBA
0 vote156 views1 answer
Excel vba populate array with cell values
VBA
0 vote178 views1 answer
Vba table header name
VBA
0 vote160 views1 answer
Vb streamreader
VBA
0 vote180 views1 answer
Regex numeric digits
VBA