/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

2 votes234 views1 answer
Excel vba extract file name
VBA
0 vote235 views1 answer
Vbnet click on dgv cells
VBA
0 vote226 views1 answer
Vb run command
VBA
0 vote224 views1 answer
Vba remove last vbcrlf
VBA
8 votes246 views1 answer
Excel vba make integer
VBA
0 vote223 views1 answer
How to extract a file from an ISO:
VBA
0 vote225 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote225 views1 answer
Vba pass named range to function
VBA
0 vote230 views1 answer
Search combobox items vb.net
VBA
0 vote213 views1 answer
Check range is in another range vba
VBA