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 vote160 views1 answer
Vba is integer
VBA
1 vote171 views1 answer
Find and replace textbox
VBA
0 vote151 views2 answers
Excel vba close without saving
VBA
2 votes149 views2 answers
Excel vba copy values range to another range
VBA
3 votes166 views1 answer
Excel vba change format of cell
VBA
1 vote150 views1 answer
What does vbs stand for
VBA
5 votes174 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote153 views1 answer
Vba border weight
VBA
0 vote204 views1 answer
Vba excel do not recalculate before save
VBA
0 vote165 views1 answer
String contins in vba
VBA