/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 vote232 views1 answer
Vba excel do not recalculate before save
VBA
0 vote179 views1 answer
Convert unix to date vba
VBA
0 vote166 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote182 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
3 votes200 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote176 views1 answer
Compare dates vb
VBA
0 vote187 views1 answer
Vba check if class implements interface
VBA
0 vote166 views1 answer
Excel vba concatenate range
VBA
1 vote165 views2 answers
Vba remove first 2 characters from string
VBA
31 votes346 views1 answer
Vba how to convert a column number into an Excel column
VBA