If this is the only solution, so I shall manage it.
but it seems too complicated writing this on code - it's a basic thing.
"Basic" to you and I, perhaps, but how would Our Friends in Redmond set
about implementing it as a Framework class?
It would be some sort of "Set" class that you could create based on a
given list of values.
Then it would have to have a Contains method (or Intersection, if this
is a Set).
Then, and this is the "Fun" part, it would have to be a Generic template
so that it could be used with objects of /any/ Type.
It's turning into a mini project all of its own.
YMMV, but I've often written my own methods for this sort of thing,
along the lines of:
Function IsIn( _
ByVal iValue As Integer _
, ByVal ParamArray iList As Integer() _
) As Boolean
For Each iEach As Integer In iList
If iEach = iValue Then
Return True
End If
Next
Return False
End Function
? IsIn( a, 1, 2, 5, 18, 13 )
HTH,
Phill W.