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 vote221 views1 answer
Excel vba protect shapes
VBA
0 vote204 views1 answer
Vba variable number of arguments
VBA
1 vote206 views1 answer
Excel vba unload userform
VBA
3 votes221 views1 answer
Excel vba change format of cell
VBA
0 vote232 views1 answer
Make your computer talk vbscript
VBA
0 vote210 views1 answer
Regex numeric digits
VBA
2 votes196 views1 answer
Vba uppercase first letter of each word
VBA
0 vote201 views1 answer
Vba loop through textboxes
VBA
1 vote221 views1 answer
Vba refresh pivot table
VBA
0 vote205 views1 answer
Vba format currency
VBA