/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 vote160 views1 answer
Vba parameter adodb null value
VBA
0 vote160 views1 answer
Vba boolean to string
VBA
0 vote159 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote169 views2 answers
Do until loop vba
VBA
5 votes137 views1 answer
Vba array worksheet.index
VBA
0 vote161 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote164 views1 answer
Vba character ascii code
VBA
1 vote157 views1 answer
Add a index column power bi
VBA
0 vote154 views1 answer
Vba code for cutoff time
VBA
0 vote153 views1 answer
Vba collection key list
VBA