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

1 vote391 views1 answer
Perform http request in vb.net
VBA
0 vote338 views1 answer
Vba DisplayGridlines
VBA
0 vote342 views1 answer
Vba compare strings
VBA
3 votes361 views2 answers
Vba active workbook path
VBA
0 vote366 views1 answer
Vba string
VBA
0 vote329 views1 answer
Vbnet check if number is even or odd
VBA
1 vote336 views1 answer
Vba date to unix timestamp
VBA
0 vote323 views1 answer
Le contrôle SpinButton (Toupie)
VBA
12 votes460 views1 answer
Excel vba write string to text file
VBA
0 vote343 views1 answer
How to get the value of optionbutton in vba
VBA