+ Reply to Thread
Results 1 to 5 of 5

Userform with checkboxs for filtering

  1. #1
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Userform with checkboxs for filtering

    I am having some issues with using this to filter my sheet. It will only filter using the first argument in my array, but is not letting me to use any of my other checkboxes (I did make sure the checkboxs are named: checkbox1 through checkbox7.

    I found the original coding for this on an old thread
    HTML Code: 
    Thank you for your help in advanced


    Please Login or Register  to view this content.
    Last edited by meabrams; 01-23-2015 at 02:47 AM. Reason: fix code tags

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Userform with checkboxs for filtering

    Maybe you should state what you want it to do. I'm not entirely sure this code does what you're expecting.

    This code filters multiple columns each with one criteria if the checkbox is checked.

    Do you want to filter on one column with one or more criteria (checkboxes)?

    Also, take note of my signature block below about code tags.
    Last edited by AlphaFrog; 01-21-2015 at 10:14 AM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: Userform with checkboxs for filtering

    I am trying to use for a single column with one/multiple selection via the checkboxes userform. I was hoping that this code was a cleaner way to code it instead of what I am currently using to do the same thing.

    And I'm sorry I did not thing to use the proper tags for my first post (noob to the forum)

    Thank you for your help

    Please Login or Register  to view this content.

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Userform with checkboxs for filtering

    That code doesn't do what you want.

    Your current code looks good to me. Here's your code cleaned up a bit.

    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: Userform with checkboxs for filtering

    Thank you for helping me clean up the code now I am running into an issue with it showing blank (no shift assigned) in the middle sheet. Is there anyway to do that with this code or do I need to go back to the original coding that was working?

+ 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] Create dynamic number of checkboxs on Userform
    By vamosj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2014, 06:27 PM
  2. Hide checkboxs with columns
    By ckk403 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-08-2013, 12:34 PM
  3. VBA Checkboxs
    By Moepat in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-22-2011, 12:25 PM
  4. Looping Checkboxs
    By jaimie1664 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2010, 11:35 AM
  5. Checkboxs Move in Document
    By Sherry in forum Excel General
    Replies: 1
    Last Post: 11-22-2005, 04:20 PM

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