/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 vote286 views1 answer
Vba array dimensions
VBA
0 vote261 views1 answer
Vb streamreader
VBA
0 vote291 views1 answer
Add text to Shape VBA
VBA
0 vote288 views1 answer
Vba character ascii code
VBA
0 vote296 views1 answer
Excel delete ever other vba
VBA
1 vote250 views1 answer
Excel vba hide zero values
VBA
5 votes268 views1 answer
Excel vba how to unit test vba code
VBA
1 vote244 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote276 views1 answer
Vba min
VBA
0 vote307 views1 answer
Excel vba first column in range
VBA