Advanced Data Structures in VBA

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

Things on this page are fragmentary and immature notes/thoughts of the author. It is not meant to readers but rather for convenient reference of the author and future improvement.

Dictionary/Hashtable

1. Set a reference to MS Scripting runtime

   Set dict = CreateObject("Scripting.Dictionary")
   

or

    Dim dict As New Scripting.Dictionary

1. Example of use:

   If Not dict.Exists(key) Then 
       dict.Add key, value
   End If
   

2. Don't forget to set the dictionary to Nothing when you have finished using it.

   Set dict = Nothing
   

Your Own Data Structure

You can define your own type in VBA.

    Dim numbers = New Integer() {1, 2, 4, 8}
    Dim doubles = {1.5, 2, 9.9, 18}

    Dim myarray As Variant
    myarray = Array("Cat", "Dog", "Rabbit")