/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 vote130 views1 answer
Vba loop through textboxes
VBA
5 votes141 views1 answer
Xlvba double quotes in string literal
VBA
0 vote117 views1 answer
Excel vba show developer tab
VBA
1 vote121 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote128 views1 answer
Vba boolean to string
VBA
3 votes135 views1 answer
Vba make long from two words
VBA
0 vote133 views1 answer
Find database connection string vb
VBA
0 vote125 views1 answer
Send text to clipboard vb.net
VBA
0 vote122 views1 answer
Excel vba current folder
VBA
0 vote133 views1 answer
Pivot data source not accepting table named range vba
VBA