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

[Monty]

Hello Expertsl!!
Need Help.
!!!!!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

 

[Monty]

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

Please find attached for Test-Solution Macro file.