/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 vote159 views1 answer
WGET FTP
VBA
20 votes328 views1 answer
Excel vba factorial
VBA
0 vote147 views2 answers
Excel vba copy paste after last row
VBA
5 votes154 views1 answer
Excel formula how to create strings containing double quotes
VBA
9 votes291 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
5 votes172 views1 answer
Excel vba right word from Long Integer
VBA
4 votes170 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote154 views1 answer
Vba timestamp -- milliseconds
VBA
5 votes135 views1 answer
Vba array worksheet.index
VBA
0 vote161 views1 answer
Set column width of datagridview vb.net
VBA