+ Reply to Thread
Results 1 to 8 of 8

Multiselect listbox preselected values from matrix

  1. 04-03-2014, 09:35 AM #1
    Biffer
    Biffer is offline
    Registered User
    Join Date
    04-24-2013
    Location
    Bristol
    MS-Off Ver
    Excel 2010
    Posts
    32

    Multiselect listbox preselected values from matrix

    Hi there

    How do I preselect items in a listbox based on combobox selection and values stored in matrix.

    I have attached the file with a description of what I mean

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-03-2014, 01:07 PM #2
    patel45
    patel45 is offline
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Multiselect listbox preselected values from matrix 

    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved
    Reply With QuoteRegister To Reply
  3. 04-03-2014, 01:55 PM #3
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Multiselect listbox preselected values from matrix

    Hi Biffer

    Try this Combobox1 Change Code 
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  4. 04-03-2014, 02:17 PM #4
    Biffer
    Biffer is offline
    Registered User
    Join Date
    04-24-2013
    Location
    Bristol
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Multiselect listbox preselected values from matrix

    Jaslake, thanks...almost!

    If I select a name from the combobox, then select another name it aggregates the listbox selections

    How do I reset each time I select a name?

    Thanks
    Reply With QuoteRegister To Reply
  5. 04-03-2014, 02:27 PM #5
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Multiselect listbox preselected values from matrix

    Geez Biffer...ya didn't say you wanted THAT...try this 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 04-03-2014, 02:58 PM #6
    Biffer
    Biffer is offline
    Registered User
    Join Date
    04-24-2013
    Location
    Bristol
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Multiselect listbox preselected values from matrix

    Thought it was obvious

    Awesome - thanks for your help
    Reply With QuoteRegister To Reply
  7. 04-03-2014, 03:06 PM #7
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Multiselect listbox preselected values from matrix

    Actually, it was...just funning with you
    Thought it was obvious
    Reply With QuoteRegister To Reply
  8. 04-03-2014, 03:10 PM #8
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Multiselect listbox preselected values from matrix

    You're welcome...glad I could help. Thanks for the Rep.

    If this resolves your issue please mark your Thread as SOLVED.

    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiselect Listbox Returning Array of Selected Index Values
    By Draco1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-27-2013, 06:46 PM
  2. 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
  3. Help! How do i populate a cell with the values selected from a multiselect listbox?
    By mamakamsi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-12-2013, 11:48 AM
  4. Multiselect form listbox - selected values to be copied and pasted in a column
    By Ath01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2013, 01:37 AM
  5. MultiSelect Listbox get/use Values
    By Ikaabod in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-30-2007, 06:27 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1