/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

22 votes352 views1 answer
Xl vba check for folder
VBA
0 vote268 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote180 views1 answer
Excel vba first working day month
VBA
0 vote197 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote207 views1 answer
Vba cell all borders
VBA
0 vote183 views1 answer
Vba range clear formatting
VBA
0 vote178 views1 answer
Openfiledialog specific folder
VBA
0 vote179 views1 answer
Excel vba range contains
VBA
5 votes195 views1 answer
Excel-vba get integer high byte
VBA
5 votes201 views1 answer
Excel vba last byte from INTEGER
VBA