/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 vote330 views1 answer
Add control vb
VBA
0 vote428 views1 answer
Wpf dark title bar
VBA
18 votes485 views3 answers
Excel-vba make integer
VBA
0 vote340 views1 answer
Excel vba remove formatting from cell
VBA
0 vote335 views1 answer
Worksheet.pastespecial textbox
VBA
1 vote318 views1 answer
Excel vba close form escape key
VBA
0 vote357 views1 answer
Excel vba named range exists
VBA
0 vote316 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote317 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote303 views1 answer
Create new worksheet excel visual basic
VBA