/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

5 votes208 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote186 views1 answer
Excel vba cell on change
VBA
0 vote194 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote238 views1 answer
Visual basic run command
VBA
0 vote196 views1 answer
Excel R1C1 mode
VBA
1 vote192 views1 answer
Excel vba array remove first
VBA
0 vote196 views1 answer
Vbnet line chart showing extra space
VBA
1 vote191 views1 answer
Excel vba force recalculation
VBA
0 vote198 views1 answer
Dynamically change drop down list visual basic
VBA
2 votes170 views2 answers
Constructor vb.net
VBA