+ Reply to Thread
Results 1 to 3 of 3

Extracting values from multiselect list box

  1. #1
    Registered User
    Join Date
    08-20-2013
    Location
    NZ
    MS-Off Ver
    Excel 2010
    Posts
    17

    Thumbs up Extracting values from multiselect list box

    Hi Guys,

    I have some code to return the values from a multiselect list box when writing the data from a userform to my worksheet. I thought it was working, but have just realised that it is not...

    I have 3 list boxes on my userform, and 3 columns that the data is to be written to.
    • List box one writes to the designated column (correct)
    • List box 2 writes the data from list box 1 & 2 to the designated column (I only want the data from the 2nd list box!)
    • List box 3 writes the data from all 3 list boxes into the column! (I only want the data from the 3rd list box!)

    I don't know how to fix it! I'm assuming I need to 'clear' it between? Code below. Please help!

    Please Login or Register  to view this content.
    Last edited by Kite3; 10-17-2013 at 09:51 PM. Reason: Solved

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Extracting values from multiselect list box

    Add these lines:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-20-2013
    Location
    NZ
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Extracting values from multiselect list box

    Excellent, thanks millz, working now

+ 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. Extracting values from a list?
    By Tomkat in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-17-2009, 05:19 AM
  2. Extracting Values in one list not on the other
    By sjanaswamy in forum Excel General
    Replies: 2
    Last Post: 09-08-2006, 07:44 PM
  3. Multiselect List Box
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2006, 01:00 PM
  4. [SOLVED] List Box - MultiSelect
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2005, 07:06 PM
  5. Extracting Values on one list and not another
    By B Schwarz in forum Excel General
    Replies: 4
    Last Post: 01-07-2005, 10:06 AM

Tags for this Thread

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