+ Reply to Thread
Results 1 to 10 of 10

Filter worksheet data using 4 dependant comboboxes and populate in 'ListBox' on a userform

Hybrid View

p_nayak268 Filter worksheet data using 4... 08-06-2013, 05:55 AM
p_nayak268 Re: Filter worksheet data... 08-07-2013, 06:29 AM
jaslake Re: Filter worksheet data... 08-07-2013, 06:59 PM
p_nayak268 Re: Filter worksheet data... 08-12-2013, 03:20 AM
jaslake Re: Filter worksheet data... 08-12-2013, 01:59 PM
p_nayak268 Re: Filter worksheet data... 08-13-2013, 06:37 AM
jaslake Re: Filter worksheet data... 08-13-2013, 04:07 PM
laurentaylor Re: Filter worksheet data... 09-27-2014, 12:34 PM
jaslake Re: Filter worksheet data... 09-27-2014, 12:41 PM
Pepe Le Mokko Re: Filter worksheet data... 09-27-2014, 12:40 PM
  1. #1
    Registered User
    Join Date
    05-21-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Filter worksheet data using 4 dependant comboboxes and populate in 'ListBox' on a user

    Hello John,



    Perfect !! Solved.

    Thanks a lot.

  2. #2
    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: Filter worksheet data using 4 dependant comboboxes and populate in 'ListBox' on a user

    You're welcome...glad I could help. Thanks for the Rep.
    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.

  3. #3
    Registered User
    Join Date
    09-27-2014
    Location
    Raleigh, NC
    MS-Off Ver
    2013
    Posts
    3

    Re: Filter worksheet data using 4 dependant comboboxes and populate in 'ListBox' on a user

    Hello John,

    I used your code in a slightly different way and I was wondering if you could help me make one tweak?

    After I make the first selection on the userform, it filters as I want, however, when I go to the next combobox it gives me all the values in that column. Is there any way to make these unique? For example, in the original document if you pick 2013, then for month Jan shows up multiple times. Any easy way to prevent this and only have it show up once?

    Any help would be greatly appreciated!

  4. #4
    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: Filter worksheet data using 4 dependant comboboxes and populate in 'ListBox' on a user

    Hi laurentaylor

    Welcome to the Forum!!!

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

+ 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. VBA userform listbox populate data entered from comboboxes
    By Hilton1982 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2012, 11:29 PM
  2. Populate text boxes dependant on the display in 2 comboboxes
    By Tony0437 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2012, 10:53 AM
  3. Replies: 4
    Last Post: 11-03-2011, 12:58 AM
  4. How to create a Userform with dependant comboboxes?
    By Danaf in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2008, 06:31 PM
  5. UserForm with Multiple ComboBoxes Populate
    By RobertCo in forum Excel General
    Replies: 2
    Last Post: 12-27-2006, 01:51 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