/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 vote212 views1 answer
Excel vba clear filter
VBA
0 vote219 views1 answer
Remove last 8 characters from string vb
VBA
0 vote215 views1 answer
Vba remove the first character of string
VBA
0 vote254 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote223 views1 answer
Set datetimepicker value to null vb
VBA
0 vote219 views1 answer
Delete all controls in an area vb
VBA
1 vote219 views1 answer
How to put a gridpain in a vbox
VBA
7 votes201 views1 answer
Vba array declaration
VBA
0 vote209 views1 answer
Vbnet check if number is even or odd
VBA
0 vote217 views1 answer
Openfiledialog specific folder
VBA