+ Reply to Thread
Results 1 to 4 of 4

Dynamic autofilter based on user selections on userform with chkboxes...

  1. #1
    Registered User
    Join Date
    06-07-2014
    Posts
    8

    Dynamic autofilter based on user selections on userform with chkboxes...

    Hello Experts..Need help! !!!!!!
    Iam working on a project where I used a userform with 10 checkboxes...and user may check any check boxes based on thuat need to autofilter data in excel sheet...your help really appreciated. ......Thankyou.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483

    Re: Dynamic autofilter based on user selections on userform with chkboxes...

    Sravanmonty
    Hi Monty, did you read the section of the forum rules I directed you to?

    My point was to actually attach a sample workbook, because nobody can work with a picture. Jeesh...

  3. #3
    Registered User
    Join Date
    06-07-2014
    Posts
    8

    Re: Dynamic autofilter based on user selections on userform with chkboxes...

    Hello Davesexcel!!
    I reframed my query according to the attached sample file......
    !!!!!When the user clicks on any of the country's name in userform(Masterfrm), then another userform should popup (CountryFrm)..showing only those states, which the user want and can select all states or multiple states and once the selection is over..clicks on confirm button and then retruns back to main form...Then clicks on autofilter button on the mainfrm which should autofilter data in excel as per user choice made on userforms....
    Thank you, your quick response and help will be appreciated.
    Monty
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-07-2014
    Posts
    8

    Re: Dynamic autofilter based on user selections on userform with chkboxes...

    Hello Experts.
    Here is the solution for multiple selection of checkboxes on userform and autofilter in excel sheet..

    Please find attatched for Test-Solution Macro file.
    Attached Files Attached Files

+ 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. 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
  2. Autofilter Based on Dropdown menue selections
    By ghoneim in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2013, 11:46 AM
  3. Replies: 3
    Last Post: 02-28-2012, 02:15 PM
  4. Building a dynamic task list based on checkbox selections
    By sstar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2011, 07:23 PM
  5. [SOLVED] Dynamic charting based on two drop down selections - help
    By TalResha in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 01-07-2011, 06:52 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