+ Reply to Thread
Results 1 to 3 of 3

Filter by Multiple Criteria coming from listbox (that can be different sizes)

  1. #1
    Forum Contributor
    Join Date
    08-23-2010
    Location
    Staten Island, NY
    MS-Off Ver
    Excel 2003
    Posts
    242

    Filter by Multiple Criteria coming from listbox (that can be different sizes)

    This code does not filter correctly.

    I have a line that is commented out in the bottom - that is an example of what types of filters I want to do but dynamically. Users choose multiselection from a list box then it filters the sheet for them. It is pulling the data from the listboxes but when it is more than one item it is Putting the whole thing in as if I said text = "ABERTI", "AMALON", "BCASTE", "BGELLE", "CFRANC" - No I want to filter by each of these (it believes this is one long string)

    Here is the code:

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    08-23-2010
    Location
    Staten Island, NY
    MS-Off Ver
    Excel 2003
    Posts
    242

    Re: Filter by Multiple Criteria coming from listbox (that can be different sizes)

    Does anyone have any ideas to help?

  3. #3
    Forum Contributor
    Join Date
    08-23-2010
    Location
    Staten Island, NY
    MS-Off Ver
    Excel 2003
    Posts
    242

    Re: Filter by Multiple Criteria coming from listbox (that can be different sizes)

    Does anyone know how to get this to work? It will not filter correctly.

+ 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. How to Filter a listbox with criteria.
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-15-2013, 03:13 AM
  2. Auto filter using selected criteria from a listbox
    By pearce.nz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-20-2013, 04:20 PM
  3. Listbox to filter multiple criteria
    By reggie1000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2013, 12:41 PM
  4. Need to filter multiple criteria in Label Filter
    By brassellc7994 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-04-2013, 12:54 PM
  5. listbox with data coming from another workbook
    By François in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2006, 09:30 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