+ Reply to Thread
Results 1 to 3 of 3

Listbox output to bookmark

  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

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Listbox output to bookmark

    Try:
    Please Login or Register  to view this content.
    PS: Code-related threads should be posted in: http://www.excelforum.com/word-programming-vba-macros/
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

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

    Re: Listbox output to bookmark

    Works a treat! Thank you.....and apologies for the wrong area.

+ Reply to Thread

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