Filter one column with multiple checkboxes

**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.