/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 vote95 views1 answer
Vba select file in folder
VBA
0 vote136 views1 answer
Excel protect cells with formulas
VBA
2 votes102 views1 answer
Excel vba pause
VBA
0 vote146 views1 answer
Excel vba Column Name to Column Number
VBA
5 votes181 views1 answer
Vba low word from Long Integer
VBA
3 votes143 views1 answer
Vba folderexists
VBA
0 vote146 views1 answer
How to use if condition in time vba
VBA
1 vote94 views1 answer
Ms access open form to new record
VBA
0 vote140 views1 answer
Excel vba ternary
VBA
0 vote149 views1 answer
Ribbon show/hide
VBA