/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

8 votes144 views1 answer
Excel vba determine number of elements in a 1D array
VBA
5 votes133 views1 answer
Excel-vba get integer high byte
VBA
0 vote126 views1 answer
Vbs
VBA
0 vote119 views1 answer
Vb.net change cursor to wait
VBA
1 vote122 views1 answer
Sort using vba
VBA
2 votes128 views2 answers
Vba code to remove duplicates from a column
VBA
0 vote123 views1 answer
Vba add month to date
VBA
0 vote112 views1 answer
Vba string start with
VBA
0 vote122 views1 answer
Worksheet.pastespecial textbox
VBA
3 votes149 views1 answer
Vba post request json
VBA