/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

3 votes253 views1 answer
Excel vba make long from two shorts
VBA
0 vote211 views1 answer
Excel named range sum
VBA
0 vote210 views1 answer
Windows Forms dark title bar
VBA
0 vote204 views1 answer
Excel vba address not absolute
VBA
5 votes214 views1 answer
Excel formula how to create strings containing double quotes
VBA
11 votes478 views1 answer
Excel vba How to URL encode a string
VBA
0 vote225 views1 answer
Excel vba named range exists
VBA
4 votes214 views2 answers
Excel vba last column with data
VBA
22 votes500 views1 answer
Excel vba check if directory exists
VBA
31 votes497 views1 answer
Excel vba function to convert column number to letter
VBA