<div>
Each day I am more and more appalled at how little I know about VBA. The Dictionary is the perfect solution for my problem. I am indebted to Matthew for his help.<br />
&nbsp; &nbsp; j.r.a.
</div>


Each day I am more and more appalled at how little I know about VBA. The Dictionary is the perfect solution for my problem. I am indebted to Matthew for his help.
    j.r.a.

<div>
Glad to help :)<br />
<br />
The Dictionary is one of my favorite objects.
</div>


Glad to help :)

The Dictionary is one of my favorite objects.

<div>
<div class="content wysiwyg-content">
Using VBA in Word, if I have stored strings in a collection, each with a different Key, is it possible to go through all the members of the collection and retrieve not only the stored string but also the key that accesses the string?<br />
&nbsp; &nbsp; &nbsp;The following code displays the strings of data stored inside &quot;MyCollection&quot;:<br />
&nbsp; &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp;Dim x as Variant<br />
&nbsp; &nbsp; &nbsp;For each x in MyCollection<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Msgbox x<br />
&nbsp; &nbsp; &nbsp;Next x<br />
<br />
&nbsp; &nbsp; &nbsp;What I need is something that will also tell me the keys that access those data.<br />
<br />
&nbsp; &nbsp; &nbsp;Thanks!<br />
<br />
&nbsp; &nbsp; &nbsp;j.r.a.
</div>
</div>


Using VBA in Word, if I have stored strings in a collection, each with a different Key, is it possible to go through all the members of the collection and retrieve not only the stored string but also the key that accesses the string?
     The following code displays the strings of data stored inside "MyCollection":
     
     Dim x as Variant
     For each x in MyCollection
         Msgbox x
     Next x

     What I need is something that will also tell me the keys that access those data.

     Thanks!

     j.r.a.

With a VBA Collection (in Word), can I access both the data and the key stored?

Microsoft Word is a commercial document editing program that is part of the Microsoft Office suite. It features numerous text-editing tools for creating richly formatted documents, along with tools for the use of macros in Word documents. Word's native file formats are denoted either by a .doc or .docx file extension. Plugins permitting the Windows versions of Word to read and write formats it does not natively support, such as the OpenDocument format (ODF) are available. Word can import and display images in common bitmap formats such as JPG and GIF. It can also be used to create and display simple line-art.

Microsoft Word

A word processor is an electronic device or computer software application that performs the task of composition, editing, formatting, and sometimes printing of documents. Most modern word processors use a graphical user interface, and most are powerful systems consisting of one or more programs that can produce any arbitrary combination of images, graphics and text, the latter handled with type-setting capability. Typical features of a modern word processor include font application, spell checking, grammar checking, a built-in thesaurus, automatic text correction, Web integration, and HTML exporting, among others.

Word Processors

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.