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.