/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 vote200 views1 answer
Open application from vbnet
VBA
0 vote236 views1 answer
If statement vdhl
VBA
2 votes202 views2 answers
Constructor vb.net
VBA
0 vote213 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote216 views1 answer
Get month number from month name vbnet
VBA
0 vote208 views1 answer
Excel vba scroll to cell
VBA
0 vote212 views1 answer
Vba html document reference
VBA
0 vote206 views1 answer
Vba code to select image in sheet
VBA
5 votes212 views1 answer
Excel vba right word from Long Integer
VBA
2 votes240 views2 answers
Excel vba if sunday or staurday
VBA