/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 vote351 views1 answer
Vba parameter adodb null value
VBA
0 vote341 views1 answer
Excel vba select multiple shapes
VBA
1 vote319 views1 answer
Excel vba last row of range
VBA
-1 vote344 views1 answer
Vba code to add new column in table
VBA
0 vote314 views1 answer
Check range is in another range vba
VBA
1 vote310 views2 answers
Excel vba password protect
VBA
2 votes279 views1 answer
Excel vba pause
VBA
0 vote342 views1 answer
Vba add shape oval
VBA
0 vote353 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote343 views1 answer
How to mount floppy disks in vb.net
VBA