Breaking News: Grepper is joining You.com. Read the official announcement!

excel vba Imitating the "IN" operator from python

Excel Hero answered on May 2, 2020 Popularity 3/10 Helpfulness 7/10

answer excel vba Imitating the "IN" operator from python

excel vba Imitating the "IN" operator from python

Comment

'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

Popularity 3/10 Helpfulness 7/10 Language vb

Source: academy.excelhero.com

Tags: excel python vba

Link to this answer
Share Copy Link