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

3 votes237 views1 answer
Excel insert blank row for value change in column
VBA
0 vote225 views1 answer
Date as number vb
VBA
0 vote225 views1 answer
String contins in vba
VBA
0 vote260 views1 answer
Vba ternary
VBA
0 vote235 views1 answer
Tester si une case est vide vba
VBA
1 vote217 views1 answer
Excel vba first and last row and column in range
VBA
8 votes301 views1 answer
Vba make integer
VBA
0 vote216 views1 answer
Vbs send keys
VBA
0 vote236 views1 answer
Return na vba
VBA
3 votes222 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA