/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

3 votes215 views1 answer
Vba http request json
VBA
5 votes221 views1 answer
Xlvba double quotes in string literal
VBA
1 vote189 views1 answer
Vba compile error object required
VBA
1 vote203 views1 answer
Add control vb
VBA
0 vote244 views1 answer
Vba dictionary clear
VBA
0 vote194 views1 answer
Vba add shape oval
VBA
0 vote203 views1 answer
Remove last 8 characters from string vb
VBA
0 vote213 views1 answer
VBA is form loaded
VBA
0 vote202 views1 answer
Excel vba hide gridlines
VBA
15 votes491 views2 answers
Xl vba dynamic string array
VBA