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 vote170 views1 answer
Excel vba first column in range
VBA
0 vote170 views1 answer
Vba random number
VBA
0 vote164 views1 answer
Vba count all row
VBA
0 vote143 views1 answer
How to use VBA to add new record in MS Access?
VBA
-1 vote145 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote154 views1 answer
Average vba
VBA
31 votes273 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote149 views1 answer
Excel R1C1 mode
VBA
0 vote157 views1 answer
Windows Forms dark title bar
VBA
0 vote143 views2 answers
Get excel file from email attachment in vba
VBA