Control an autofilter using Checkbox Control

[evyxmsj]

Hello all,

My first post in the forum! I'm trying to create and control an autofilter using a check box control, for a single column.

The data is simply a "y" or left blank, and I want a check box control to filter all the rows with "y" (if checked), and display all results (blank or "y") if unchecked. Preferably, I would like the control caption to be descriptive, rather than the criteria.

I had started with an approach using the following, though I freely admit I could be on the wrong track (and I'm a VBA newbie):

Please Login or Register  to view this content.

With:

Please Login or Register  to view this content.

That seems to work for filtering the "y" values. But I couldn't get anywhere with a Macro2 to show all results. It doesn't run when I uncheck the box

Any advice?

EDIT: I should add that I'll be doing the same thing for multiple columns.

[evyxmsj]

Here an example of what I was trying to do.Book 1.xlsm