habiler
10-05-2022, 01:22 AM
Hello Community,
I’ve been looking for some way to filter with checkboxes.
In one sheet ("category") I have several checkboxes where the .caption of each checkbox returns a value from column B of the sheet("Data") A,B,C,D.
My goal is that when I select the checkbox A a selection is displayed of all records having the . caption (or the A)30205 value of column B (or A and B if checkbox B is also checked. Style filter function for example or by displaying data (in sheet ("Category")
In addition I also have a selection in ("B1")
Most examples on the internet show me a solution with .autofilter. But are there examples (or is it possible) to use only Filter? But how.
Thank you in advance for your invaluable assistance.
Habils
I’ve been looking for some way to filter with checkboxes.
In one sheet ("category") I have several checkboxes where the .caption of each checkbox returns a value from column B of the sheet("Data") A,B,C,D.
My goal is that when I select the checkbox A a selection is displayed of all records having the . caption (or the A)30205 value of column B (or A and B if checkbox B is also checked. Style filter function for example or by displaying data (in sheet ("Category")
In addition I also have a selection in ("B1")
Most examples on the internet show me a solution with .autofilter. But are there examples (or is it possible) to use only Filter? But how.
Thank you in advance for your invaluable assistance.
Habils