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

20 votes164 views1 answer
Excel vba recursive example factorial function
VBA
0 vote146 views1 answer
How to enter Vbox manage commands
VBA
0 vote136 views1 answer
Excel vba urlmon
VBA
0 vote141 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote120 views1 answer
Excel vba ternary
VBA
0 vote125 views1 answer
Vbs write file
VBA
0 vote132 views1 answer
Winforms dark title bar
VBA
0 vote116 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote127 views1 answer
Vba word pdf table to excel
VBA
2 votes123 views2 answers
Constructor vb.net
VBA