View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Piotr Lipski Piotr Lipski is offline
external usenet poster
 
Posts: 36
Default 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