/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 vote144 views1 answer
Add Formula to Shape Text in VBA
VBA
22 votes285 views1 answer
Excelvba check for directory
VBA
0 vote137 views1 answer
Vba argument is set
VBA
0 vote138 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote158 views4 answers
How to continue formula in below line in vba code
VBA
0 vote163 views1 answer
Write listbox to text file vb.net
VBA
0 vote172 views1 answer
Vba random number
VBA
0 vote106 views1 answer
Vbide vbproject reference
VBA
0 vote187 views1 answer
Vbnet check if string is only letters
VBA
1 vote147 views1 answer
Vba reverse string
VBA