/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

0 vote342 views1 answer
Arq linux
VBA
1 vote333 views1 answer
Vba refresh pivot table
VBA
0 vote344 views2 answers
Excel vba copy paste after last row
VBA
0 vote370 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote362 views3 answers
Write to text file vb.net
VBA
1 vote333 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote332 views1 answer
Vba simple quote
VBA
2 votes333 views1 answer
Vba split string
VBA
2 votes335 views1 answer
Excel vba check if string entirely numeric
VBA
3 votes378 views1 answer
Vba continue for each loop
VBA