/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 vote140 views1 answer
Vba vbcrlf chr
VBA
1 vote127 views1 answer
If inputbox cancel vba
VBA
0 vote127 views1 answer
Test if form is open vb
VBA
0 vote125 views1 answer
Type excel.application is not defined vb
VBA
9 votes256 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
5 votes131 views1 answer
Excel formula how to create strings containing double quotes
VBA
1 vote127 views2 answers
Get all column names from excel vba
VBA
0 vote118 views1 answer
Style percent not found vba
VBA
0 vote76 views1 answer
Vba select file in folder
VBA
0 vote131 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA