/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

1 vote166 views1 answer
Close form vba
VBA
0 vote161 views1 answer
Vba option button selected
VBA
2 votes174 views1 answer
Vba round number
VBA
0 vote176 views1 answer
Nested if else in vb.net
VBA
0 vote179 views1 answer
Delete all controls in an area vb
VBA
-1 vote225 views1 answer
Vba sendkeys
VBA
0 vote175 views1 answer
Average vba
VBA
1 vote169 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote158 views1 answer
Excel vba milliseconds
VBA
0 vote159 views1 answer
Quit excel with save changes dialog vb.net
VBA