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 vote145 views2 answers
Vba string length
VBA
5 votes151 views1 answer
Excel vba low word from Long Integer
VBA
0 vote148 views1 answer
Excel vba StartUpPosition
VBA
0 vote150 views1 answer
Vba simple quote
VBA
1 vote123 views2 answers
Vba remove first 2 characters from string
VBA
0 vote131 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote136 views1 answer
Vba leading zeros in string
VBA
0 vote145 views1 answer
Refresh token em vb net
VBA
0 vote136 views1 answer
Telephon call in vba
VBA
0 vote149 views1 answer
Excel vba open browser
VBA