Have you tried using the Dictionary object (from the MS Scripting library)?

--
Tim Williams
Palo Alto, CA


"Piotr Lipski" wrote in message ...
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