+ Reply to Thread
Results 1 to 7 of 7

Populate Lisbox with rows filtered by combobox value

  1. #1
    Registered User
    Join Date
    05-23-2017
    Location
    Warsaw,Poland
    MS-Off Ver
    2013
    Posts
    3

    Populate Lisbox with rows filtered by combobox value

    Hello,

    I'm new here. I want to make a simple thing.

    I have a table in sheet named "Stock" with owner's staff (equipment, date from, date to and owner's name)
    I put combobox with owners names in "list" Sheet and also a listbox

    Now when I choose one owner name from combobox I want listbox to populate all rows with selected owner's name.

    I tried this macro but it only populates lisbox with first column and it takes a lot of time...


    Please Login or Register  to view this content.
    Please, maybe You could help me find better way to do this..
    I don't want to do a userform because I want to have at least 3 listboxes form different sheets in "List" sheet.

    Here is a xlsm file.
    Attached Files Attached Files
    Last edited by arturreter; 05-24-2017 at 06:21 AM.

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Populate Lisbox with rows filtered by combobox value

    Try this sub
    Please Login or Register  to view this content.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Populate Lisbox with rows filtered by combobox value

    Try the attached.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    05-23-2017
    Location
    Warsaw,Poland
    MS-Off Ver
    2013
    Posts
    3

    Re: Populate Lisbox with rows filtered by combobox value

    Thanks You both.

    Tsjallie - your code is cool and works fast but it still gives only one column in listbox

    jindon - Your version works perfect - just as I wanted. Many thanks!

  5. #5
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Populate Lisbox with rows filtered by combobox value

    To have more columns, change this line
    Please Login or Register  to view this content.
    into
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    05-23-2017
    Location
    Warsaw,Poland
    MS-Off Ver
    2013
    Posts
    3

    Re: Populate Lisbox with rows filtered by combobox value

    Thanks a lot!

  7. #7
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Populate Lisbox with rows filtered by combobox value

    Thx fort the rep
    If you problem is solved pls mark the thread SOLVED (see thread tools in the menu above)

+ 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] Code required to Auto Populate 3rd Combobox based on 02nd Combobox Selection
    By bimmy80 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-14-2015, 03:56 AM
  2. [SOLVED] How do I populate a specific range in one ComboBox based of selection of another ComboBox?
    By gmr4evr1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-04-2015, 04:32 PM
  3. Combobox filtered with textbox; Listview filtered by combobox
    By Arvin.Amaro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2015, 11:48 AM
  4. Userform Combobox to populate form: Can I change the order of the columns in the combobox?
    By CraigWiggins in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2014, 12:14 PM
  5. [SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 04:50 PM
  6. Populate ComboBox with rows that meet criterion
    By val64 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-05-2011, 12:46 PM
  7. Populate filtered rows
    By ajaykgarg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2010, 03:48 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