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 vote360 views1 answer
Vba static variable
VBA
0 vote338 views1 answer
Excel R1C1 mode
VBA
0 vote355 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote346 views2 answers
Excel vba protect cells with formula
VBA
0 vote339 views1 answer
Change "location" of binding navigator vb
VBA
0 vote360 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote358 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote367 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote346 views1 answer
Reset border color textbox vba
VBA
0 vote380 views1 answer
Excel vba named range exists
VBA