/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 vote256 views1 answer
Add items to combobox vb.net
VBA
2 votes232 views1 answer
Excel vba pause
VBA
1 vote281 views1 answer
Excel vba first row in range
VBA
0 vote416 views1 answer
Vba array of integers
VBA
8 votes330 views1 answer
Run command pormpt in background windows
VBA
0 vote304 views1 answer
How to enter Vbox manage commands
VBA
0 vote291 views1 answer
Vba sheet hide unhide
VBA
0 vote261 views1 answer
Vba dropdown event
VBA
0 vote301 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote277 views1 answer
Excel vba scroll to cell
VBA