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 vote336 views1 answer
Add text to Shape VBA
VBA
0 vote324 views1 answer
For each item in folder outlook vba
VBA
0 vote317 views1 answer
Do while not vb.net
VBA
3 votes315 views1 answer
Vba request json
VBA
1 vote303 views2 answers
Vba remove first 2 characters from string
VBA
0 vote315 views1 answer
Limit combobox to list vba
VBA
0 vote336 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote318 views1 answer
Vba check if class implements interface
VBA
0 vote321 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote309 views1 answer
Vb.net change cursor to wait
VBA