/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 vote239 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote256 views1 answer
Send webhook vbscript
VBA
1 vote241 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote256 views1 answer
VBA
VBA
0 vote242 views1 answer
VBA Loop to range
VBA
0 vote223 views1 answer
Vba get text file content
VBA
8 votes322 views1 answer
Excel vba make word from bytes
VBA
0 vote268 views1 answer
Vba registry settings
VBA
-1 vote271 views1 answer
Code for reading letters only in vb 6
VBA
0 vote276 views1 answer
Vba userform textbox wrap text
VBA