/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 vote340 views1 answer
Set datetimepicker value to null vb
VBA
5 votes366 views1 answer
Xlvba double quotes in string literal
VBA
0 vote306 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote305 views1 answer
Vba loop through table
VBA
0 vote314 views1 answer
Telephon call in vba
VBA
0 vote324 views2 answers
How to concatenate more than 40 lines in vba
VBA
4 votes309 views1 answer
Excel vba check cell not empty
VBA
0 vote308 views1 answer
Excel vba scroll to cell
VBA
0 vote316 views1 answer
Show unix time in vba
VBA
0 vote331 views1 answer
Loop through all text boxes in a form vb
VBA