+ Reply to Thread
Results 1 to 4 of 4

Filter using combo box

  1. #1
    Registered User
    Join Date
    02-03-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    32

    Filter using combo box

    Hi!

    I want to filter my results using a combo box on my spreadsheet. I don't mind how this is done, even if it just hides all of the information which isn't relevant. I've done it with a VLookup but I want to be able to edit it easily without the formula popping up. So if you click Barlcays, only barclays appears. I'd also like a button to reset if possible. I've attached an example of how I sort of want it to work.

    Any help would be greatly received!

    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Filter using combo box

    Example 1.xlsm

    Hows that?
    It's macro controlled so you need to enable macros
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    02-03-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: Filter using combo box

    That is exactly what I wanted thank you so much! Just one thing, is there a way I can have a button to get rid of the filter and show everything (a show all button). Thanks!

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,754

    Re: Filter using combo box

    See attached. Added two buttons. Also changed the combo box from an ActiveX combo to data validation lookup.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Replies: 8
    Last Post: 12-26-2013, 02:23 PM
  2. Filter using Combo Box
    By 301eco in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-13-2012, 10:54 PM
  3. Great Combo Filter/Search form, cant get DATE filter to integrate. HELP
    By fau5tu5 in forum Access Programming / VBA / Macros
    Replies: 4
    Last Post: 05-18-2009, 05:05 PM
  4. How can i Apply a filter to a combo box
    By L_ter in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2009, 06:56 AM
  5. [SOLVED] Combo Box filter with autocomplete
    By renaissanceme@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-14-2006, 04:20 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