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

25 votes253 views2 answers
Excel vba folder exist
VBA
0 vote218 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote191 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote198 views1 answer
Vbscript abs
VBA
0 vote198 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote194 views1 answer
Check if program is running vbnet
VBA
0 vote195 views1 answer
Vba change named range address
VBA
3 votes202 views1 answer
Vba http request json
VBA
0 vote208 views1 answer
Excel vba delete folder
VBA
1 vote228 views1 answer
Excel vba convert text YYYYMMDD to date
VBA