+ Reply to Thread
Results 1 to 3 of 3

List ListBox multiselect items in a single cell in separate lines NOT using string commas

  1. #1
    Registered User
    Join Date
    10-04-2018
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    58

    List ListBox multiselect items in a single cell in separate lines NOT using string commas

    Hello,

    I am attempting to use a list box with the multiselect items in a Userform and I am trying to find a way to have the form show the information in a separate table under the proper heading as separate line items.

    So far I have been able to get the form to put the items in the correct place in my table, but I cannot get them to list on new lines. Using the comma separation just looks messy too for my list items. The ultimate goal would be to be able to filter the table by each item, but I don't think that's possible at all without having them in new rows...

    Any suggestions?? I think needs to be adjusted below is: If .Selected(i) = True Then s = s & .List(i) & vbNewLine

    HTML Code: 

  2. #2
    Registered User
    Join Date
    10-04-2018
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    58

    Re: List ListBox multiselect items in a single cell in separate lines NOT using string com

    Anyone have any ideas???

  3. #3
    Registered User
    Join Date
    10-04-2018
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    58

    Re: List ListBox multiselect items in a single cell in separate lines NOT using string com

    Even if this can't be done?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] ListBox - Copy all selected options into a single cell seperated by commas
    By AusTempest in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 03-31-2014, 08:04 AM
  2. [SOLVED] For next loop multiselect activex listbox won't list items in seperate cells. Only 1st
    By Dabbler39 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-05-2013, 03:25 PM
  3. Copy Selected items from multicolumn, multiselect listbox to another listbox
    By Willigb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2013, 11:27 AM
  4. [SOLVED] How do I combine multiple lines of information into a single cell, separated by commas?
    By ilostar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2012, 11:48 AM
  5. Multiselect ListBox - Active/Inactive Items
    By LCK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2005, 08:45 PM
  6. [SOLVED] Multiselect ListBox - Active/Inactive Items
    By LCK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2005, 06:17 PM
  7. Redispay multiselect listbox items after saving and closing excelf
    By Amzee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2005, 06:06 PM

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