LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
arrays in arrays jacob Excel Programming 4 August 29th 04 08:40 PM
Arrays Kenny Excel Programming 5 August 26th 04 09:47 AM
using arrays in vba JulieD Excel Programming 4 August 12th 04 04:59 PM
Help with arrays please Gary[_18_] Excel Programming 6 June 27th 04 08:29 PM
arrays again RobcPettit Excel Programming 3 January 24th 04 10:33 PM


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"