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 vote184 views1 answer
Vba sendkeys
VBA
0 vote174 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote186 views1 answer
Vba html document reference
VBA
8 votes328 views1 answer
Vba make a short integer from two bytes
VBA
0 vote184 views1 answer
Vba code to select image in sheet
VBA
0 vote231 views1 answer
Excel vba delete columns in range
VBA
1 vote165 views1 answer
Textbox find and replace vb
VBA
1 vote192 views1 answer
Vba loop through files in folder
VBA
0 vote183 views1 answer
String contins in vba
VBA
1 vote172 views2 answers
Vba find last row in range for certain criteria
VBA