/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 vote197 views1 answer
Excel vba address not absolute
VBA
0 vote293 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote203 views1 answer
Vbs send keys
VBA
0 vote224 views1 answer
Build an index all files of a FTP site
VBA
5 votes182 views1 answer
Vba array worksheet.index
VBA
0 vote194 views1 answer
Vbs exec hidden
VBA
-1 vote199 views1 answer
Vba code to add new column in table
VBA
0 vote207 views1 answer
Vba file chooser
VBA
0 vote211 views1 answer
Dynamically change drop down list visual basic
VBA
2 votes216 views1 answer
Vba file from path
VBA