/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 vote277 views1 answer
Remove first character from string vb
VBA
1 vote270 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote304 views1 answer
Vba excel parser xml
VBA
0 vote307 views1 answer
Excel vba protect sheet
VBA
0 vote299 views1 answer
VBA is form loaded
VBA
0 vote248 views1 answer
How to sort datagridview in vb.net
VBA
3 votes293 views1 answer
Excel vba change format of cell
VBA
0 vote298 views1 answer
.net crash app
VBA
1 vote297 views1 answer
VBA Loop through recordset
VBA
0 vote276 views1 answer
Check if program is running vbnet
VBA