/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

1 vote128 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote148 views1 answer
Average vba
VBA
3 votes138 views1 answer
Extract the nth word from a text string
VBA
1 vote155 views1 answer
Vba optional
VBA
2 votes149 views2 answers
Vba code to remove duplicates from a column
VBA
0 vote143 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote148 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote166 views1 answer
Vba cell all borders
VBA
1 vote165 views1 answer
Perform http request in vb.net
VBA
8 votes188 views1 answer
Excel vba make word
VBA