/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 vote186 views1 answer
Vba compare strings
VBA
2 votes177 views1 answer
Excel vba date to string conversion
VBA
0 vote187 views1 answer
Excel vba protect worksheet without password
VBA
0 vote184 views1 answer
Vba DisplayGridlines
VBA
0 vote183 views1 answer
Vba leading zeros in string
VBA
0 vote190 views1 answer
Excel VBA web scraping
VBA
0 vote172 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote174 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote131 views1 answer
How to make a if statement with vbs
VBA
0 vote186 views1 answer
Vb net dgv doesn't keep currency format
VBA