Filter one column with multiple checkboxes

**jaslake** · 10-23-2012, 04:49 PM

Hi pjohnson05

Here's a slightly different approach...using Cells as Check Boxes. Double Click on any Cell in Range C3:C6 to check or uncheck the cell then click the Filter Me Button.
Let me know of issues.

**pjohnson05** · 10-23-2012, 05:00 PM

Thanks for the quick response jaslake!

Works like a charm! Is there a reason why we can't use check boxes? Would that require to much Code? Also, just curious as to why it doesn't refresh after each selection (Filter Me button)?

**jaslake** · 10-23-2012, 05:11 PM

Hi pjohnson05

If you're working on Book1 v1.xlsm and have checked any cells in Sheets Data in Range C3:C6 (Double LEFT Click to check or uncheck) and then clicked the FilterMe Button and nothing happens then I have no thoughts. I've tested the code and it works as designed on my platform in Excel 2010.

**pjohnson05** · 10-23-2012, 05:18 PM

Sorry jaslake...I had the old workbook open still and that was causing the issue.

Couple questions if you have time....Is there a reason why we can't use check boxes? Would that require to much Code? Also, just curious as to why it doesn't refresh after each selection (Filter Me button)?

**jaslake** · 10-23-2012, 05:27 PM

Hi pjohnson05

As I mentioned,

this is slightly different approach...using Cells as Check Boxes

Sure, we can use Check Boxes. You develop them in your worksheet, where you want them, how they'll be labeled and I'll help you write the code.

Regarding this

just curious as to why it doesn't refresh after each selection

On my platform, if you CHANGE the selections and press the Filter Me Button it does refresh to reflect the new selections.

**pjohnson05** · 10-23-2012, 05:52 PM

Great! Thanks so much buddy. It would really be ideal if I had checkboxes.

See attached for a new schedule with ActiveX checkboxes.

**jaslake** · 10-23-2012, 06:57 PM

Hi pjohnson05

See code in attached for ActiveX Check Boxes.

**Songbook** · 08-29-2014, 11:58 AM

Thank you guys for this stuff, I'll surely use it in one of my projects.It's really close to what I'm looking for. Even though, my preference was to have these controls in a userform rather than a worksheet. Thank you jaslake for the support.