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

5 votes190 views2 answers
Excel vba write to the windows registry
VBA
-1 vote180 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote195 views1 answer
Vba listbox remove all items
VBA
2 votes178 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote166 views1 answer
Do until vb.net
VBA
0 vote174 views1 answer
How to format a textbox as date vb net
VBA
0 vote182 views1 answer
Vba is integer
VBA
3 votes180 views1 answer
Extract the nth word from a text string
VBA
1 vote186 views1 answer
Vba login website
VBA
0 vote165 views1 answer
Vba loop through textboxes
VBA