/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 vote262 views1 answer
Vba loop through files in folder
VBA
0 vote244 views1 answer
Convert unix to date vba
VBA
0 vote259 views3 answers
Write to text file vb.net
VBA
1 vote241 views1 answer
Add a index column power bi
VBA
0 vote232 views1 answer
Vba first line of string
VBA
0 vote226 views1 answer
Find the name of the last excel sheet vb
VBA
1 vote233 views2 answers
Vba remove first 2 characters from string
VBA
0 vote247 views1 answer
Vbnet hex to binary
VBA
0 vote251 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote240 views1 answer
Excel vba automatic calculation
VBA