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 vote249 views3 answers
Write to text file vb.net
VBA
0 vote239 views1 answer
Vb get ip address
VBA
0 vote235 views1 answer
Vbnet check if string is only numbers
VBA
0 vote229 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote249 views4 answers
Jwt token vb.net validation
VBA
1 vote243 views2 answers
Vba string length
VBA
0 vote238 views1 answer
Excel vba cell on change
VBA
12 votes283 views1 answer
Excel vba write string to text file
VBA
0 vote240 views1 answer
Vba dictionary clear
VBA
-1 vote240 views2 answers
Excel vba delete empty rows
VBA