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 vote188 views2 answers
Excel vba protect cells with formula
VBA
5 votes188 views1 answer
Excel vba left word from Long Integer
VBA
2 votes179 views1 answer
Excel vba check if string entirely numeric
VBA
0 vote183 views1 answer
Vba verticalalignment
VBA
2 votes196 views2 answers
Excel vba if sunday or staurday
VBA
25 votes345 views2 answers
Excel vba folder exist
VBA
0 vote176 views1 answer
Vbscript remove spaces from string
VBA
0 vote173 views1 answer
Vba open report
VBA
0 vote220 views1 answer
Wpf dark title bar
VBA
0 vote189 views1 answer
VBA Loop to range
VBA