/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 vote236 views1 answer
Vba date to unix timestamp
VBA
0 vote230 views1 answer
WGET FTP
VBA
0 vote237 views1 answer
Excel vba cell on change
VBA
0 vote230 views1 answer
Excel vba select multiple shapes
VBA
0 vote230 views1 answer
Vb net dgv doesn't keep currency format
VBA
1 vote238 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote211 views1 answer
Vba code to open a file with login rights
VBA
0 vote249 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote253 views1 answer
Vba multiple optional arguments
VBA
0 vote293 views1 answer
Visual basic cmd
VBA