/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 vote96 views1 answer
Vba delete file
VBA
0 vote122 views1 answer
Vba table header name
VBA
0 vote102 views1 answer
Vba remove numbers from string
VBA
0 vote103 views1 answer
Vb get ip address
VBA
0 vote104 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote97 views1 answer
Afficher un message d'erreur vba
VBA
0 vote89 views1 answer
Docker vboxmanage not found
VBA
0 vote111 views1 answer
Vbscript Trim
VBA
0 vote103 views1 answer
Vba open report
VBA
0 vote104 views1 answer
Vb test if reference is null
VBA