/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 vote223 views1 answer
Nested if else in vb.net
VBA
0 vote230 views2 answers
Open url from vba
VBA
0 vote222 views1 answer
Compare dates vb
VBA
0 vote216 views1 answer
Vba find sub dictionary
VBA
0 vote232 views1 answer
Open file dialog in vb.net
VBA
1 vote220 views1 answer
Vba date to unix timestamp
VBA
0 vote221 views1 answer
Vbs write file
VBA
0 vote217 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote234 views1 answer
Excel vba named range exists
VBA
1 vote240 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA