Vba collection key list

' Use a Dictionary instead of a Collection
Dim dict As Dictionary
Set dict = New Dictionary

dict.Add "key1", "value1"
dict.Add "key2", "value2"

Dim key As Variant
For Each key In dict.Keys
    Debug.Print "Key: " & key, "Value: " & dict.Item(key)
Next

Source: stackoverflow.com

Similar codes

0 vote243 views1 answer
Excel vba show developer tab
VBA
0 vote248 views1 answer
Excel vba protect worksheet without password
VBA
0 vote238 views1 answer
Vba DisplayGridlines
VBA
0 vote256 views1 answer
Excel vba named range exists
VBA
0 vote254 views1 answer
Get month number from month name vbnet
VBA
0 vote254 views1 answer
Excel vba select multiple shapes
VBA
0 vote242 views1 answer
Excel vba protect content
VBA
0 vote228 views1 answer
Vba pass named range to function
VBA
0 vote256 views1 answer
Vba sort the data Z to A
VBA
0 vote242 views1 answer
Convert number to minutes in vba
VBA