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 vote189 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote178 views1 answer
VBA is form loaded
VBA
0 vote168 views1 answer
Dynamic array vba
VBA
0 vote221 views2 answers
Excel vba store array and write to sheet
VBA
0 vote202 views1 answer
Vbnet check if string is only letters
VBA
2 votes163 views1 answer
Excel vba check if key is in collection
VBA
0 vote162 views1 answer
Vba get relative cell address
VBA
1 vote160 views1 answer
If inputbox cancel vba
VBA
15 votes241 views1 answer
Excel vba wait
VBA
0 vote164 views1 answer
Vbnet hex to binary
VBA