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 vote215 views1 answer
Hello world vb.net
VBA
0 vote225 views1 answer
Average vba
VBA
0 vote216 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
22 votes534 views1 answer
Xl vba check for folder
VBA
1 vote230 views1 answer
Excel vba last row of range
VBA
1 vote215 views1 answer
Excel vba hide zero values
VBA
18 votes567 views2 answers
Vba make word from bytes
VBA
3 votes225 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote231 views1 answer
Worksheet.pastespecial textbox
VBA
3 votes243 views1 answer
Vba request json
VBA