Question : vba collection key list
Answered by : vastemonde
' 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)
NextSource : https://stackoverflow.com/questions/5702362/vba-collection-list-of-keys | Last Update : Sun, 07 Feb 21