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 vote295 views1 answer
Vba horizontalalignment
VBA
0 vote274 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote263 views1 answer
Excel vba populate array with cell values
VBA
1 vote290 views1 answer
Vba date to unix timestamp
VBA
0 vote268 views1 answer
Vba copy paste value only
VBA
1 vote239 views1 answer
Vba exit do while
VBA
0 vote292 views1 answer
How to add line graph vb net
VBA
31 votes395 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote279 views1 answer
Vba type variable
VBA
1 vote278 views1 answer
Excel vba make cell visible
VBA