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 vote224 views1 answer
Vbnet get file name from path
VBA
0 vote275 views1 answer
.net crash app
VBA
0 vote245 views1 answer
Vba dropdown event
VBA
1 vote225 views1 answer
Vba ubound array 2-dimensional
VBA
15 votes475 views1 answer
Excel vba wait
VBA
18 votes416 views3 answers
Excel-vba make integer
VBA
0 vote226 views1 answer
Afficher un message d'erreur vba
VBA
0 vote269 views1 answer
Excel vba ternary
VBA
0 vote273 views1 answer
Excel vba urlmon
VBA
0 vote255 views1 answer
Excel filter by date not working vba
VBA