/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 vote207 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote240 views1 answer
Vba excel do not recalculate before save
VBA
8 votes206 views1 answer
Run command pormpt in background windows
VBA
0 vote195 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote190 views1 answer
Excel vba first working day month
VBA
0 vote189 views1 answer
Loop through lines in text file vb net
VBA
0 vote185 views1 answer
Vba boolean to string
VBA
0 vote202 views1 answer
VBA
VBA
0 vote189 views1 answer
Vba sort the data Z to A
VBA
1 vote185 views1 answer
Excel vba close form escape key
VBA