/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 vote212 views1 answer
Vba exit while
VBA
0 vote233 views1 answer
Vba run command
VBA
4 votes230 views2 answers
Excel vba last column with data
VBA
0 vote210 views1 answer
Handling a click event anywhere inside a panel vb
VBA
3 votes228 views1 answer
Vba double quote
VBA
1 vote232 views1 answer
Vba login website
VBA
0 vote224 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote239 views1 answer
Vba open report
VBA
0 vote221 views1 answer
Label de tableau dans des label.text en VBA
VBA
6 votes221 views1 answer
Excel vba get the path of current workbook
VBA