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 vote299 views1 answer
Vba boolean to string
VBA
0 vote267 views1 answer
Vbscript Trim
VBA
0 vote273 views1 answer
Vba find sub dictionary
VBA
0 vote296 views2 answers
Checking and changing system volume vb.net
VBA
0 vote265 views1 answer
Vba line feed
VBA
6 votes309 views1 answer
Excel vba isalpha
VBA
1 vote262 views1 answer
Highlight selected cell in excel vba
VBA
0 vote284 views1 answer
Nested if else in vb.net
VBA
-1 vote259 views1 answer
Text to speech vb.net
VBA
0 vote269 views1 answer
Backspace key has stopped working visual studio
VBA