Results 1 to 5 of 5

Running an Advanced Filter using Userform check boxes

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2010
    Location
    Cambridge
    MS-Off Ver
    Excel 2003
    Posts
    3

    Question Running an Advanced Filter using Userform check boxes

    Hi, could someone please help.

    I have created a userform with 6 check boxes and labels which relate to the content of columns D and P in a table. The user can select any combination of these check boxes. There are also 2 command buttons; one to Enter and one to Cancel.

    [x] London store (Column D)
    [ ] Cambridge store (Column D)
    [ ] Bananas (Column P)
    [x] Oranges (Column P)
    [x] Apples (Column P)
    [ ] Pears (Column P)

    What I would like to happen is for the check boxes to define the criteria for an advanced filter. For example, if the user were to select check boxes 1, 4 and 5, the table would be filtered to show only the rows that contain 'London store' and 'Oranges' OR 'London Store' and 'Apples'.

    What I'm struggling with is the code to put behind the user form, check boxes and command buttons. Also, 6 checkbox choices = 64 possible combinations so I'm assuming I need to have a spearate criteria table showing all 64 combinations for the adv filter to look at?

    Help on any of the above will be very gratefully received
    Last edited by gr6au; 08-21-2011 at 05:13 PM.

Thread Information

Users Browsing this Thread

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

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