How can I store both key and value in VBA?

[Chip Pearson]

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.


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

 

[Guest]

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!