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 vote159 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote171 views1 answer
Excel vba set cell value to empty
VBA
0 vote169 views1 answer
Vba dictionary length
VBA
0 vote177 views1 answer
Find if year is leap year vb
VBA
0 vote155 views1 answer
Make all controls in an area not visable vb
VBA
3 votes211 views2 answers
Excel "vba" match last value
VBA
0 vote189 views1 answer
Vba foreach 2d array
VBA
0 vote159 views1 answer
Vbscript abs
VBA
0 vote164 views1 answer
Worksheet.pastespecial textbox
VBA
1 vote151 views1 answer
Textbox find and replace vb
VBA