/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 vote261 views1 answer
Vbs run with cscript
VBA
2 votes223 views1 answer
Vba array contains
VBA
-1 vote219 views2 answers
How close excel through visual basic
VBA
0 vote225 views1 answer
Excel vba current folder
VBA
22 votes302 views1 answer
Excel vba check if directory exists
VBA
0 vote232 views1 answer
Excel vba automatic calculation
VBA
0 vote254 views1 answer
Vba listbox remove all items
VBA
0 vote240 views1 answer
Vba table header name
VBA
1 vote242 views2 answers
Vba string length
VBA
2 votes221 views1 answer
Excel vba extract file name
VBA