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.
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.
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...
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks