Checkboxes and filters

[habiler]

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)Screenshot 2022-10-05 100055.jpg 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

[snb]

Use a dynamic Table.
Autofilter is the best way to achieve your goal.

[p45cal]

cross posted