/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 vote207 views1 answer
Vb run command
VBA
0 vote208 views1 answer
Vba clear collection
VBA
1 vote195 views1 answer
Random number generator vb.net
VBA
0 vote190 views1 answer
Vba declare 64-bit ptrsafe
VBA
0 vote189 views1 answer
Vb streamreader
VBA
0 vote196 views1 answer
Vba text to general
VBA
2 votes194 views1 answer
Vba file from path
VBA
0 vote214 views1 answer
Group controls programmatically vb
VBA
2 votes191 views1 answer
Excel vba check if key is in collection
VBA
0 vote189 views1 answer
Excel vba range contains
VBA