Use Checkbox and Combobox as filter

[charleswang]

Hi all,

I am new to VBA and really got problems that i could not solve. Will be appreciated for you kind help!

In the attached, the effect I want is to (separate two things)

1. tick the check box(single or multiple) on the "cover" sheet, and then click the demand button "Basic Information", and then it will lead me to the "basic info" sheet with the column A "Province" filtered.

2. again tick the check box (single or multiple) on the "cover" sheet as the first criteria (corresponding to the column M: "Headquarter" on "companies" sheet), and then click the demand button "Listed Companies", which will show me the userform to let me choose from the combo boxes, and then click "OK" and it will hopefully lead me to the results on "companies" sheet which are satisfied with the 4 criteria (Provinces ticked in the check box, and other 3 in the userform). I may have some thoughts for a single check box (didn't work that nicely though), but really hv no clue for multiple check boxes.

I have tried to create the combo box already but failed to deal with the check box as the first-layer filter (or run with the combo box at the same time)

Sorry to bother but will be more than grateful for your help! Can you kindly give me a hint or give me some examples in the attached so that I can try harder to figure out the rest?

Thanks...a million...lol. Pls see attached as below.

Trial start 20150805.xlsm