The attached example provides the user with 2 comboboxes and 2 textboxes which together create data that is sent to a listbox which is then outputted into word, the format is shown below...
Combobox1 + Textbox1 = "Item #1"
Combobox2 + Textbox2 = "Item #2"
The above is ONE record and is copied to Listbox1 in the format "Item #1" & " " & "Item #2"...This all appears on the same row but in two columns.
When they are sent to Bookmark1 a single record in Listbox1 appears fine, as shown below,
Item 1: "Data",
Item 2: "Data". i.e., each column of the single record entered onto its own line...
The problem is that when Listbox1 contains more than one record (row of data), the way the code is currently set up ensures that the records flow into each other, line after line, as shown below,
Item 1: "Data",
Item 2: "Data",
Item 1: "Data",
Item 2: "Data",
Item 1: "Data",
Item 2: "Data",
Item 1: "Data",
Item 2: "Data".
When what I need to happen is this,
Item 1: "Data",
Item 2: "Data".
Item 1: "Data",
Item 2: "Data".
Item 1: "Data",
Item 2: "Data".
Item 1: "Data",
Item 2: "Data".
etc.
Can anyone please suggest a solution,
thanks
Bookmarks