+ Reply to Thread
Results 1 to 3 of 3

Turn comma seperated list into a range for listbox selections

  1. #1
    Registered User
    Join Date
    02-24-2019
    Location
    UK
    MS-Off Ver
    Mac 365
    Posts
    81

    Turn comma seperated list into a range for listbox selections

    I have this code to transfer the selections made in a multi-select listbox into a single text box (TextBoxSupportHelper), then using more code (not shown here) I transfer the Comma seperated list from the TextBox to an Excel table. I am wondering how to do all of the above in reverse? i.e. use comma seperated list from Excel cell to highlight selections in multi-select list box.

    As an example the listbox shows following values A, B, C, D, E. The Excel cell with comma seperated list contains A, D, E - so I want A, D and E to be selected/highlighted in the listbox.

    I presume I could create a helper table and setup some sort of text to columns and transpose routine, but ideally would like to do this without creating another table.


    Please Login or Register  to view this content.
    Last edited by chris01395; 11-26-2020 at 09:36 AM.

  2. #2
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,586

    Re: Turn comma seperated list into a range for listbox selections

    Hi chris01395,

    One way ... Check attached file
    Please Login or Register  to view this content.
    Attached Files Attached Files
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  3. #3
    Registered User
    Join Date
    02-24-2019
    Location
    UK
    MS-Off Ver
    Mac 365
    Posts
    81

    Re: Turn comma seperated list into a range for listbox selections

    Perfect! Thank you, exactly what I was looking for.

+ 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] Name (Value) in comma seperated list
    By sl968 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-16-2020, 05:52 PM
  2. [SOLVED] VBA code to create comma seperated list with one condition
    By Delta729 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-05-2018, 12:06 PM
  3. Creating a comma seperated list based on a search criteria from a column
    By HUGH JORGAN in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2013, 05:20 PM
  4. [SOLVED] Macro to change data entered in a cell seperated by a comma, into a vertical list of data
    By jholly3 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-13-2012, 03:51 PM
  5. Comma seperated list of numbers
    By krspa9 in forum Excel General
    Replies: 1
    Last Post: 07-24-2009, 05:24 AM
  6. How to split a value seperated by comma?
    By Ticktockman in forum Excel General
    Replies: 2
    Last Post: 03-23-2006, 12:25 PM
  7. Reading from comma seperated List
    By Shashi Bhosale in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2005, 03:05 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