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 vote180 views2 answers
Excel vba store array and write to sheet
VBA
0 vote131 views1 answer
Vbnet cycle through charaters in string
VBA
0 vote146 views1 answer
Find if year is leap year vb
VBA
0 vote131 views1 answer
Excel vba automatic calculation
VBA
5 votes76 views1 answer
Vlookup vba
VBA
0 vote123 views1 answer
Vba code for cutoff time
VBA
0 vote133 views1 answer
Nested if else in vb.net
VBA
0 vote135 views1 answer
Change form background image vb
VBA
0 vote160 views1 answer
How to enter Vbox manage commands
VBA
1 vote143 views1 answer
Export datagridview to excel vb.net
VBA