/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

1 vote228 views1 answer
Export datagridview to excel vb.net
VBA
0 vote224 views1 answer
Menus act like radio buttons vb.net
VBA
5 votes161 views1 answer
Vlookup vba
VBA
0 vote224 views1 answer
Set column width of datagridview vb.net
VBA
4 votes258 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote234 views1 answer
Vbnet click on dgv cells
VBA
0 vote234 views1 answer
VBA is form loaded
VBA
0 vote239 views1 answer
Vba random number
VBA
1 vote206 views1 answer
Excel vba convert cells(1,1) into A1 and vice versa
VBA
0 vote224 views1 answer
Openfiledialog specific folder
VBA