Results 1 to 3 of 3

Listbox output to bookmark

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-08-2009
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    223

    Listbox output to bookmark

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1