/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 vote228 views1 answer
Show unix time in vba
VBA
0 vote212 views1 answer
Excel VBA web scraping
VBA
0 vote204 views1 answer
Remove frist letter from string vbnet
VBA
0 vote231 views1 answer
Supprimer la valeur de celule vba
VBA
7 votes224 views1 answer
Vba array declaration
VBA
5 votes238 views1 answer
Excel vba low byte from INTEGER
VBA
1 vote216 views1 answer
Textbox find and replace vb
VBA
0 vote231 views1 answer
Vba count all row
VBA
0 vote243 views1 answer
Vba round to 2 decimals
VBA
0 vote225 views1 answer
How to make a if statement with vbs
VBA