Autofilter a column by multiple checkboxes in userform

[impresxy]

Hi,

I am looking for VBA code that allows my user to checkbox (multiple combination) in userform and autofilter only one column.

my checkboxes are

(x) AA
(x) BB
( ) CC
(x) AB
( ) AC

I want this to be able to filter my column G with what selected.

Please kindly help

[kasan]

Hi,
Your column G contains AA, BB, CC, AB, AC and other data, right?
And now you want to filter out only values with filled checkbox, right?
Could you please attach sample file with data in column G and userform with checkboxes.

[xlnitwit]

Hi,

Here is some sample code

Please Login or Register  to view this content.

[impresxy]

Hi,

Here is some sample code

Please Login or Register  to view this content.

Hi xlnitwit,
and you save my day once again!! Thank you so much

[Benten667]

Hi,

It is possible to use this code for all sheets of a Excel ?

Thanks