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 vote298 views1 answer
Vba sheet hide unhide
VBA
1 vote295 views1 answer
Vba optional
VBA
0 vote304 views1 answer
Vba add spaces
VBA
0 vote326 views1 answer
Excel vba protect scenarios
VBA
0 vote375 views1 answer
Wpf dark title bar
VBA
4 votes299 views1 answer
Excel vba determine number of elements in an array
VBA
1 vote278 views1 answer
Highlight selected cell in excel vba
VBA
0 vote306 views1 answer
Vba open report
VBA
0 vote290 views1 answer
Dynamic array vba
VBA
0 vote288 views1 answer
Search in richtextbox vb.net
VBA