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 vote239 views1 answer
Create links in msgbox in vb
VBA
6 votes245 views1 answer
Excel vba get the path of current workbook
VBA
0 vote241 views1 answer
Vba min
VBA
0 vote191 views10 answers
Vba excel create event log
VBA
0 vote257 views1 answer
Excel vba move down to next visible cell
VBA
0 vote225 views1 answer
Vba add shape oval
VBA
0 vote227 views1 answer
Get current year vb
VBA
0 vote257 views1 answer
Columns dont autoresize on program start vb.net
VBA
6 votes264 views1 answer
Excel vba isalpha
VBA
0 vote229 views1 answer
Vb net dgv doesn't keep currency format
VBA