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

13 votes500 views2 answers
Vba write text file
VBA
0 vote316 views1 answer
How to sort datagridview in vb.net
VBA
0 vote500 views1 answer
Vba change active sheet
VBA
0 vote365 views1 answer
Vba sort multiple columns
VBA
0 vote367 views4 answers
How to continue formula in below line in vba code
VBA
0 vote350 views1 answer
Vba exit while
VBA
0 vote393 views1 answer
Sort dictionary by key vba
VBA
0 vote355 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote359 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote375 views1 answer
Date as number vb
VBA