/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 vote178 views1 answer
Search combobox items vb.net
VBA
8 votes219 views1 answer
Vba make a short integer from two bytes
VBA
0 vote183 views1 answer
Make your computer talk vbscript
VBA
1 vote171 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote169 views1 answer
Telephon call in vba
VBA
0 vote168 views1 answer
Excel vba disable mouse click
VBA
0 vote187 views1 answer
Remove series name from legendvbnet
VBA
0 vote156 views1 answer
Excel vba current folder
VBA
20 votes236 views1 answer
Excel vba recursive example factorial function
VBA
2 votes128 views1 answer
Excel vba pause
VBA