/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 vote132 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
1 vote138 views1 answer
Excel vba last row of range
VBA
0 vote130 views1 answer
Vba extract filename from path
VBA
0 vote137 views1 answer
Vba dictionary clear
VBA
0 vote116 views1 answer
Find days in month vba
VBA
1 vote151 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote134 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote132 views1 answer
Vba boolean to string
VBA
-1 vote129 views1 answer
Vba code to add new column in table
VBA
0 vote138 views1 answer
Excel last used row
VBA