/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 vote190 views1 answer
Excel vba automatic calculation
VBA
0 vote207 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote186 views1 answer
Excel vba formatconditions range
VBA
0 vote177 views1 answer
Vbnet dynamically change excel sheet name
VBA
18 votes458 views2 answers
Vba make word from bytes
VBA
-1 vote183 views1 answer
Vba code to add new column in table
VBA
1 vote172 views2 answers
Vba remove first 2 characters from string
VBA
0 vote206 views1 answer
Vba search string position
VBA
0 vote183 views1 answer
Vba full date format
VBA
0 vote195 views1 answer
VBA OR vb6 find OR replace string from the end
VBA