/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 vote169 views1 answer
Vba simple quote
VBA
2 votes110 views1 answer
Excel vba pause
VBA
0 vote188 views1 answer
Vba foreach 2d array
VBA
1 vote157 views1 answer
Change the first item in a queue vb.net
VBA
3 votes170 views1 answer
Vba http request json
VBA
0 vote170 views1 answer
Vba listbox remove all items
VBA
0 vote193 views1 answer
Winforms dark title bar
VBA
1 vote158 views1 answer
Add a index column power bi
VBA
0 vote166 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote157 views1 answer
Vba border weight
VBA