/VBA/Excel vba check if key is in collection

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)

Source: academy.excelhero.com

Similar codes

1 vote216 views1 answer
Excel vba compare 2 rows
VBA
0 vote199 views1 answer
Enter into cells data grid view
VBA
0 vote221 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote230 views1 answer
Date as number vb
VBA
0 vote192 views1 answer
Excel vba concatenate range
VBA
15 votes280 views2 answers
Xl vba dynamic string array
VBA
0 vote232 views1 answer
Vba test optional argument
VBA
0 vote230 views1 answer
Dynamic array vba
VBA
5 votes240 views2 answers
Excel vba write to the windows registry
VBA
1 vote221 views1 answer
Vba compile error object required
VBA