Hash Table/Associative Array in VBA

by

I think you are looking for the Dictionary object, found in the Microsoft Scripting Runtime library. (Add a reference to your project from the Tools…References menu in the VBE.)

It pretty much works with any simple value that can fit in a variant (Keys can’t be arrays, and trying to make them objects doesn’t make much sense. See comment from @Nile below.):

Dim d As dictionary
Set d = New dictionary

d("x") = 42
d(42) = "forty-two"
d(CVErr(xlErrValue)) = "Excel #VALUE!"
Set d(101) = New Collection

You can also use the VBA Collection object if your needs are simpler and you just want string keys.

I don’t know if either actually hashes on anything, so you might want to dig further if you need hashtable-like performance. (EDIT: Scripting.Dictionary does use a hash table internally.)

More Related Contents:

  1. VBA hash string
  2. Multidimensional associative arrays in Bash
  3. Loop Through All Subfolders Using VBA [duplicate]
  4. Combine rows / concatenate rows
  5. How to convert VBA script to Google Apps Script automatically?
  6. What is the difference between Dim, Global, Public, and Private as Modular Field Access Modifiers?
  7. How do I base64 encode a string efficiently using Excel VBA?
  8. How to move each emails from inbox to a sub-folder [duplicate]
  9. Best workaround for VBA Transpose array length limit?
  10. I use OR to form a multiple condition IF ELSE statement on VBA, it’s not working
  11. VBA- variable in a range, inside a formula
  12. How to Lock the data in a cell in excel using vba
  13. Check for the senderEmailAddress
  14. Removing a string that includes CRLF characters from body of e-mail
  15. Workbooks.Open Method in VBA
  16. Windows().Activate works on every computer except one
  17. VBA: How long does On Error Resume Next work?
  18. Exporting MS Access Forms and Class / Modules Recursively to text files?
  19. How can I assign a Variant to a Variant in VBA?
  20. VBScript to open a dialog to select a filepath
  21. How can I create text files with special characters in their filenames
  22. Creating form programmatically in the module using vba
  23. Macro to update all fields in a word document
  24. Find and FindNext for Excel VBA
  25. How can I automatically populate the VBA Editor with line numbers?
  26. Why are hash table expansions usually done by doubling the size?
  27. Debugging an Outlook 2007 script fired by a rule
  28. Start VBA macro when editing a cell
  29. VBA Run-time error 438 appears when “paste” runs
  30. If Not function proceeds when value *is* the one specified

Leave a Comment