/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

2 votes156 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote168 views1 answer
Delete all controls in an area vb
VBA
7 votes172 views1 answer
Excerl vba array to range
VBA
0 vote155 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote157 views1 answer
Excel vba linter
VBA
3 votes147 views1 answer
Excel vba read registry key value
VBA
25 votes292 views3 answers
String to date vb
VBA
0 vote153 views1 answer
Vba first line of string
VBA
0 vote152 views1 answer
Excel vba existence of a file
VBA
0 vote158 views1 answer
Excel vba protect worksheet without password
VBA