/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 vote150 views1 answer
Vba full date format
VBA
0 vote146 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote151 views1 answer
Vba loop through textboxes
VBA
0 vote147 views1 answer
Vb test if reference is null
VBA
0 vote153 views1 answer
VBA Sleep Snippet
VBA
0 vote180 views1 answer
Check if cell is dbnullvb.net
VBA
1 vote100 views1 answer
How to open cmd with vbd
VBA
0 vote160 views1 answer
Vba min
VBA
0 vote146 views1 answer
Enable macros on opening workbook vba
VBA
0 vote156 views1 answer
Windows Forms dark title bar
VBA