/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 vote382 views1 answer
Excel delete ever other vba
VBA
0 vote360 views1 answer
Vba test optional argument
VBA
1 vote372 views2 answers
Get all column names from excel vba
VBA
1 vote358 views1 answer
Excel vba force recalculation
VBA
20 votes499 views1 answer
Excel vba recursive example factorial function
VBA
0 vote339 views1 answer
Change "location" of binding navigator vb
VBA
0 vote376 views1 answer
Excel vba combine ranges
VBA
0 vote342 views1 answer
Dlete rows with blanks and space " " vba
VBA
4 votes353 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote326 views1 answer
Excel vba formatconditions range
VBA