/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 vote152 views1 answer
Excel vba chrw max value
VBA
0 vote154 views1 answer
Excel vba disable keyboard input
VBA
5 votes134 views1 answer
Vba array worksheet.index
VBA
1 vote184 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote217 views1 answer
Excel vba add reference programmatically
VBA
3 votes168 views1 answer
Vba double quote
VBA
0 vote182 views1 answer
Excel vba move down to next visible cell
VBA
0 vote151 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote156 views1 answer
Vba first line of string
VBA
0 vote154 views1 answer
Visual basic msdos
VBA