Is there anything in VBA that works similar in any way to a Hash Map collection in java?
I assume an ordinary Array is the closest thing. Right?

Not really. VBA.Collection would be the closest equivalent and no hashing is needed. (it's probably more like a linked list dictionary than a hash map).

I don't think VBA has anything that's a true hash map. Why would you need one?


EDIT: Corrected the description. Dictionary is more accurate description as VBA.Collection has the capacity to refer to objects by key; linked lists doesn't, though a dictionary may be a linked list itself.

If storing and retrieving key=value pairs is the main consideration there is also the scripting.dictionary object that
is similar to the vba.collection object with the addition of a few useful methods and capabilities not found in the
vba.collection object.