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 vote231 views1 answer
Columns dont autoresize on program start vb.net
VBA
5 votes215 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote225 views1 answer
Excel vba first working day month
VBA
0 vote202 views1 answer
Afficher un message d'erreur vba
VBA
0 vote209 views1 answer
Internet explorer reference vba
VBA
4 votes230 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote224 views1 answer
Power query M substract minimum value of column -dax
VBA
4 votes202 views1 answer
Excel vba check cell not empty
VBA
3 votes232 views1 answer
Excel insert blank row for value change in column
VBA
0 vote241 views1 answer
How to enter Vbox manage commands
VBA