I am working on a listbox that pulls information from a table in another word document. Currently, the connection between the parent document listbox and the tabe is working (the listbox populates properly), and the document variables are populated correctly. In short it's working fine with the listbox set to accept single selections.



What I'd like to have is the first listbox open to multiple selections, however, I'm having trouble with the code to transfer multiselections to the variables in the document upon execution of the OK command button. I assume I need some sort of a loop to do this. The table has only two columns and a variable number of rows.

I am adapting code found in a FAQ by Greg Maxey which has been very helpful (Thanks Greg).

Here's the code for the OK button:

Thanks!

Perhaps my original post was unclear. I am a novice at VBA and need help with a bit of code to pass selected items from a multi-select listbox to a document. The selected items have the following format, and they need to appear in this format in the output document. The source document has a table with the information in two columns (one for the citation and one for the text), and the target document uses variables as insertion points.

H&SC 17920.3(A)(1)
EMC 150.162 (A)(1) Lack of, or improper water closet, lavatory, bathtub or shower in a dwelling or lodging house.

H&SC 17920.3(A)(2)
EMC 150.162 (A)(2) Lack of, or improper water closets, lavatories and bathtubs or showers per number of guests in hotel.

H&SC 17920.3(A)(3)
EMC 150.162 (A)(3) Lack of, or improper kitchen sink in a dwelling unit.


The listbox works fine, I just need help with the output. From what I've read, I'm looking for a loop that transfers the selected items to the target document, but I'm unclear on how to accomplish this. Am I looking to transfer the slected items to an array and then populate the variable with the array, or is there some other way to transfer multple selections to a single variable?

Any help is great appreciated.