/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 vote312 views1 answer
Vba add shape oval
VBA
-1 vote336 views1 answer
Code for reading letters only in vb 6
VBA
3 votes337 views1 answer
Excel vba make long from two shorts
VBA
3 votes299 views1 answer
Excel vba read registry key value
VBA
0 vote270 views1 answer
How to self delete a vbscript file
VBA
0 vote308 views1 answer
Limit combobox to list vba
VBA
0 vote338 views1 answer
Vba find last column in a row with data
VBA
0 vote336 views1 answer
Tester si une case est vide vba
VBA
0 vote312 views1 answer
VB Error Code BC30201
VBA
0 vote319 views1 answer
Excel vba first working day month
VBA