Associative arrays in VBA?
I wonder how do *real* VBA Gurus (TM) implement an associative array.
I do it like this:
- create array of keys
- create separate arrray of values
- create function GetValueByKey, which looks for a given key in the first
array and returns corresponding element from the second one.
- create function SetKeyAndValue...
- create function RemoveValueByKey...
Etc., etc., but this is very inefficient. There should be some smart way of
implementing it...
--
PL
|