/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 vote233 views1 answer
Export datagridview to excel vb.net
VBA
3 votes251 views1 answer
Extract word in a text in excel
VBA
1 vote241 views1 answer
Vb.net get name by Cell Click
VBA
0 vote239 views1 answer
Vb get ip address
VBA
2 votes230 views2 answers
Vba code to remove duplicates from a column
VBA
5 votes259 views1 answer
Excel vba low word from Long Integer
VBA
1 vote243 views1 answer
What does vbs stand for
VBA
1 vote234 views1 answer
Vba delete file
VBA
0 vote231 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote233 views1 answer
Visual stuiod not recognising desgined labels
VBA