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

1 vote202 views1 answer
Random number generator vb.net
VBA
0 vote216 views1 answer
Vba html document reference
VBA
0 vote232 views1 answer
Vba vbcrlf chr
VBA
0 vote211 views1 answer
Menus act like radio buttons vb.net
VBA
1 vote214 views1 answer
Add rows to datagridview vb.net
VBA
1 vote201 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote221 views1 answer
How to add line graph vb net
VBA
1 vote208 views1 answer
Export datagridview to excel vb.net
VBA
0 vote193 views1 answer
Vba createparameter null
VBA
0 vote217 views1 answer
Default host vbox address
VBA