/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 vote343 views1 answer
Create links in msgbox in vb
VBA
0 vote315 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote343 views4 answers
Vgrive,deb
VBA
0 vote314 views1 answer
Telephon call in vba
VBA
2 votes303 views1 answer
Vba array contains
VBA
0 vote312 views1 answer
Vba remove numbers from string
VBA
0 vote327 views1 answer
How to add line graph vb net
VBA
0 vote320 views1 answer
Not allow form to be resized
VBA
4 votes324 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote350 views1 answer
Supprimer la valeur de celule vba
VBA