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 vote316 views1 answer
Excel vba round to whole number
VBA
0 vote328 views1 answer
How to format a textbox as date vb net
VBA
0 vote313 views1 answer
Vbnet add axis labels to chart
VBA
1 vote327 views1 answer
Vb.net get name by Cell Click
VBA
0 vote336 views2 answers
Excel vba number format file size
VBA
0 vote304 views1 answer
Reset border color textbox vba
VBA
27 votes454 views2 answers
Vba check if file exists
VBA
5 votes343 views1 answer
Vba low word from Long Integer
VBA
0 vote331 views1 answer
Excel named range sum
VBA
8 votes377 views1 answer
Excel vba determine number of elements in a 2D array
VBA