/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 vote246 views1 answer
Visual stuiod not recognising desgined labels
VBA
5 votes252 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote246 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote238 views1 answer
Vba array of integers
VBA
0 vote219 views1 answer
Vba like with wildcard
VBA
0 vote240 views1 answer
Excel vba prevent saving workbook
VBA
1 vote248 views1 answer
Perform http request in vb.net
VBA
0 vote239 views1 answer
VB Error Code BC30201
VBA
1 vote222 views1 answer
Excel vba last column in range
VBA
0 vote222 views1 answer
WGET FTP
VBA