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 vote155 views1 answer
Excel vba center userform
VBA
0 vote160 views1 answer
Add items to combobox vb.net
VBA
0 vote166 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote153 views1 answer
Vba file size
VBA
1 vote180 views1 answer
Vba loop through files in folder
VBA
0 vote168 views1 answer
Show unix time in vba
VBA
4 votes164 views1 answer
Excel vba how to reset usedrange
VBA
0 vote173 views1 answer
Open file dialog in vb.net
VBA
0 vote166 views1 answer
Dynamic array vba
VBA
5 votes171 views1 answer
Excel vba low word from Long Integer
VBA