/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 vote359 views1 answer
Vbscript for loop
VBA
3 votes357 views1 answer
Excel vba change format of cell
VBA
0 vote367 views1 answer
Vba range clear formatting
VBA
31 votes516 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote382 views1 answer
Vba sort the data Z to A
VBA
0 vote338 views2 answers
Excel vba close without saving
VBA
0 vote357 views1 answer
Remove frist letter from string vbnet
VBA
0 vote347 views1 answer
Vbnet check if string is only symbols
VBA
0 vote366 views1 answer
Vba collection key list
VBA
0 vote374 views1 answer
Columns dont autoresize on program start vb.net
VBA