+ Reply to Thread
Results 1 to 5 of 5

Userform with multiple checkboxes with more than 2 criterias

  1. #1
    Registered User
    Join Date
    06-06-2016
    Location
    Hamburg, Germany
    MS-Off Ver
    Excel 2010
    Posts
    3

    Thumbs up Userform with multiple checkboxes with more than 2 criterias

    Hello guys. I'm new here

    I post an introduction post earlier today, but I cannot see it so I hope it's gonna be ok.

    I have an excel-lent problem for all of you. It drives me crazy, and maybe you can help me.

    So I will add an exemple also you will be able to understand more, but:

    I have a colum (D) in which I can find some informations (1->8) and when you clic on the button filter an userform pop and then you just have to choose the checkbox(-es) you want and then "filter" in order to see only the lines you wanted.

    But it's not working at all... I tried to look in this forum, on internet, in many thing, but I've never seen with 8 checkboxes.

    So maybe you have a solution OR a better idea.

    Cause to add a problem on the top of this (yes I like when it's difficult) for 1, 2 and 3 I need 3 criterias for each... And obviously checkbox allow me only with 2 criterias.


    thank for reading me and for helping in any case, cause I'm on this problem since days, and I haven't found a solution.

    You will find in the file that I tried a start of code, but it's always "need to debug" or "just not working"....


    So thank you


    Ok obivously the attachement is not working (I have some trouble here with some internet pages...), so I will try to add my code here directly:


    Please Login or Register  to view this content.

    Thank you in advance!!
    Last edited by Gorbu; 06-07-2016 at 11:14 AM.

  2. #2
    Forum Contributor
    Join Date
    01-20-2012
    Location
    Amsterdam, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    186

    Re: Userform with multiple checkboxes with more than 2 criterias

    Hi Gorbu, welcome.
    Please try this below.
    You might want to consider recording your filters.

    Please Login or Register  to view this content.
    Regards,
    Rick

  3. #3
    Registered User
    Join Date
    06-06-2016
    Location
    Hamburg, Germany
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Userform with multiple checkboxes with more than 2 criterias

    Hey Rick, and Dank u!!

    Quick answer!!

    Look, I'm trying my best to understand your code, but I've to admit... I can't.

    But I tried to use it, and unfo it's not working... Obviously I have to "debug" here: "Rng.AutoFilter Field:=4, Criteria1:="1", Operator:=xlOr, Criteria2:="2"" OR here " .AutoFilter.Range.SpecialCells(xlCellTypeVisible).Copy"

    So maybe, I didn't understand correctly...

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    06-06-2016
    Location
    Hamburg, Germany
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Userform with multiple checkboxes with more than 2 criterias

    Euxaristw polu Fotis1991. Kai signomi...

    Twra einai entaksei;

    I hope it's okay right now, in order to have some solutions

    Wish you a good evening!
    Last edited by Gorbu; 06-07-2016 at 11:34 AM.

  5. #5
    Forum Contributor
    Join Date
    01-20-2012
    Location
    Amsterdam, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    186

    Re: Userform with multiple checkboxes with more than 2 criterias

    Hi Gorbu,

    I assumed your data was on row 10 and below based on the fact your autofilter is set to D10.
    However, this might not be the case.
    If you can attach a sample sheet, I'm happy to help you further.

    Regards,
    Rick

+ 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] Toggle between userform checkboxes for multiple pairs of checkboxes
    By L plates in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-25-2016, 06:31 AM
  2. [SOLVED] Error Checking Multiple Checkboxes in a Userform
    By mo4391 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2016, 12:01 PM
  3. [SOLVED] Userform search data by multiple criterias
    By SamGeron in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2015, 08:54 AM
  4. Autofilter with multiple checkboxes selections on userform with vba
    By Sravanmonty in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2014, 08:37 PM
  5. [SOLVED] Userform with multiple checkboxes used for autofilter
    By JorisDDS in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-21-2014, 10:41 AM
  6. [SOLVED] Call different macros using multiple control checkboxes in a userform
    By Sideshow1447 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-04-2013, 04:39 PM
  7. Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 03-05-2013, 11:12 AM

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