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 vote127 views1 answer
Excel vba assign shortcut key to button
VBA
12 votes236 views1 answer
Excel vba write string to text file
VBA
1 vote125 views1 answer
Excel vba get column name from number
VBA
1 vote122 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote117 views1 answer
Excel vba hide columns
VBA
0 vote132 views1 answer
Vbscript Trim
VBA
0 vote133 views1 answer
Vba clear collection
VBA
0 vote121 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote125 views1 answer
Telephon call in vba
VBA
0 vote125 views1 answer
Vba apostrophe chr
VBA