/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 vote220 views1 answer
Export datagridview to excel vb.net
VBA
5 votes227 views1 answer
Xlvba double quotes in string literal
VBA
1 vote209 views1 answer
Vba delete file
VBA
1 vote223 views1 answer
Vbs run
VBA
2 votes207 views1 answer
Excel vba check if key is in collection
VBA
0 vote231 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote215 views1 answer
Sort dictionary by key vba
VBA
0 vote211 views2 answers
Excel vba close without saving
VBA
0 vote193 views1 answer
Vba code to open a file with login rights
VBA
0 vote216 views1 answer
Vba first line of string
VBA