/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 vote145 views1 answer
VBA Sleep Snippet
VBA
0 vote151 views1 answer
Add text to Shape VBA
VBA
2 votes142 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
1 vote138 views1 answer
Excel vba close form escape key
VBA
6 votes138 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote139 views1 answer
Excel vba prevent saving workbook
VBA
0 vote130 views1 answer
Vba test optional argument
VBA
0 vote140 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote137 views1 answer
VB Error Code BC30201
VBA
0 vote137 views1 answer
Vb net dgv doesn't keep currency format
VBA