Have you looked at the Collection object ?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"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