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
VBA
VBA
0 vote152 views1 answer
Vba sheet hide unhide
VBA
4 votes151 views1 answer
Vba create directory
VBA
1 vote146 views1 answer
VBA Loop through recordset
VBA
0 vote151 views1 answer
Internet explorer reference vba
VBA
0 vote159 views2 answers
Vba remove line breaks
VBA
0 vote157 views1 answer
Label de tableau dans des label.text en VBA
VBA
3 votes162 views1 answer
Excel vba change format of cell
VBA
0 vote150 views1 answer
Vb net dgv doesn't keep currency format
VBA
1 vote104 views1 answer
How to open cmd with vbd
VBA