/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 vote204 views1 answer
Vba parameter adodb null value
VBA
0 vote246 views1 answer
Vb ternary
VBA
1 vote198 views2 answers
Vba remove first 2 characters from string
VBA
0 vote202 views1 answer
Select case vba
VBA
0 vote219 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote214 views1 answer
Xlbycolumns is not declared
VBA
3 votes206 views1 answer
Excel vba read registry key value
VBA
0 vote226 views1 answer
Vbnet click on dgv cells
VBA
0 vote204 views1 answer
Excel vba disable copy paste
VBA
0 vote219 views1 answer
Excel vba copy range with filter
VBA