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 vote316 views1 answer
Vb window.minimize
VBA
0 vote344 views1 answer
Loop through all text boxes in a form vb
VBA
1 vote344 views2 answers
Get all column names from excel vba
VBA
0 vote361 views1 answer
Excel vba first column in range
VBA
0 vote361 views1 answer
Vba boolean to string
VBA
0 vote335 views1 answer
Vba collection contains
VBA
1 vote339 views1 answer
What does vbs stand for
VBA
0 vote335 views1 answer
Excel vba Column Name to Column Number
VBA
5 votes410 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote321 views1 answer
Vb check if row has column
VBA