/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 vote253 views2 answers
How close excel through visual basic
VBA
0 vote272 views1 answer
Excel run macro every 5 minutes
VBA
3 votes264 views1 answer
Vba folderexists
VBA
0 vote261 views1 answer
Vba string start with
VBA
0 vote277 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote269 views1 answer
Vbs write file
VBA
0 vote276 views1 answer
Vba code for cutoff time
VBA
0 vote255 views1 answer
Do until vb.net
VBA
0 vote287 views1 answer
Get month number from month name vbnet
VBA
0 vote260 views1 answer
Change form background image vb
VBA