collection check if ket exists code example
Example: excel vba check if key is in collection
'A Dictionary is a better choice when you need to determine if a key
'is already in the collection. But here is a VBA function that
'reports True or False for Collections:
Function KeyExists(key$, c As Collection)
On Error Resume Next
c.Item key
KeyExists = Err = 0: Err.Clear
End Function
'--------------------------------------------------------------------
MsgBox KeyExists("Netflix", colFANG)