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 vote176 views1 answer
Vba dictionary length
VBA
0 vote180 views1 answer
Hello world vb.net
VBA
0 vote185 views1 answer
How to add line graph vb net
VBA
2 votes178 views1 answer
Excel vba date to string conversion
VBA
0 vote173 views1 answer
Vb.net round to 2 decimal places
VBA
1 vote182 views1 answer
Excel format cell as kilowatts
VBA
0 vote198 views1 answer
Excel vba protect sheet
VBA
0 vote187 views1 answer
Vba string
VBA
0 vote174 views1 answer
Vba loop through textboxes
VBA
1 vote199 views1 answer
Set font for ms chart vb.net
VBA