/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

6 votes349 views1 answer
Excel vba get the path of current workbook
VBA
0 vote303 views1 answer
Excel vba show developer tab
VBA
1 vote322 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
1 vote292 views2 answers
Excel vba password protect
VBA
3 votes302 views1 answer
Vba folderexists
VBA
0 vote297 views1 answer
Vba exit while
VBA
0 vote355 views1 answer
Vba userform textbox wrap text
VBA
0 vote336 views1 answer
Excel vba set cell value to empty
VBA
0 vote353 views1 answer
Application.ExecutablePath VB.NET
VBA
1 vote308 views1 answer
Excel vba first row in range
VBA