/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 vote153 views1 answer
Vb net show lines for all axis labels in chart
VBA
1 vote153 views1 answer
Add a index column power bi
VBA
0 vote152 views1 answer
Test if form is open vb
VBA
3 votes167 views2 answers
Vba active workbook path
VBA
2 votes152 views1 answer
Excel vba extract file name
VBA
0 vote164 views1 answer
Vba exit while
VBA
0 vote165 views1 answer
Open file dialog in vb.net
VBA
0 vote163 views1 answer
Weekday vba
VBA
-1 vote154 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote150 views1 answer
How to use VBA to add new record in MS Access?
VBA