/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 vote175 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
8 votes325 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote170 views1 answer
Excel vba disable alerts
VBA
0 vote180 views1 answer
Remove first character from string vb
VBA
0 vote173 views1 answer
Vba option button selected
VBA
0 vote174 views1 answer
Vbs write file
VBA
-1 vote173 views1 answer
Text to speech vb.net
VBA
0 vote184 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
0 vote186 views1 answer
For each item in folder outlook vba
VBA
0 vote167 views1 answer
Backspace key has stopped working visual studio
VBA