/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 vote171 views1 answer
Windows Forms dark title bar
VBA
8 votes175 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote176 views1 answer
Priavte sub with multiple handels find sneder
VBA
2 votes157 views1 answer
Date format for ms chart vb.net
VBA
0 vote159 views1 answer
Vbscript for loop
VBA
0 vote161 views1 answer
Vb net show lines for all axis labels in chart
VBA
9 votes302 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote123 views1 answer
Vba set vs dim
VBA
0 vote213 views1 answer
Vba excel do not recalculate before save
VBA
0 vote123 views1 answer
Vba code to remove leading and trailing spaces
VBA