How can I store both key and value in VBA?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dev - 25 Jan 2007 23:08 GMT

I am trying to create a hashtable with key value pairs - where both key and
value are strings. How to do this using VBA?

Thanks for any help!

Reply to this Message

Chip Pearson - 25 Jan 2007 22:29 GMT

You might try using a Dictionary object. Have a look at
http://www.cpearson.com/excel/CollectionsAndDictionaries.htm for VBA utility
procedures for Dictionaries and Collections. To use a dictionary, you'll
need a reference (in VBA, Tools menu, References) to the "Microsoft
Scripting Runtime" library.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email on the web site)

>I am trying to create a hashtable with key value pairs - where both key and
> value are strings. How to do this using VBA?
>
> Thanks for any help!

Reply to this Message