/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

2 votes240 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote255 views1 answer
Vba clear collection
VBA
0 vote289 views1 answer
Winforms dark title bar
VBA
0 vote347 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote255 views1 answer
Remove first character from string vb
VBA
0 vote229 views1 answer
How to use if condition in time vba
VBA
11 votes517 views1 answer
Excel vba How to URL encode a string
VBA
0 vote239 views1 answer
Move bindingnavigator vb
VBA
0 vote281 views1 answer
VBA Sort RossetaCode
VBA
0 vote230 views1 answer
Vb check if row has column
VBA