Filter one column with multiple checkboxes

Hi excel guru's!!

I am in need of some VBA coding that will allow me to filter a specific column with multiple check boxes. For example, I have a worksheet with over 100 rows of data and each row in column B has a month. Can I have check boxes for each month and filter my data based on the check boxes that I select?

I have been able to write some code that allows me to filter for just one month, but I cannot seem to figure our how to get multiple months.

Thanks for all your help!!

Please attach a sample workbook and give specific examples of what you want to accomplish. I am sure what you want to accomplish is possible but your question seems a bit vague.

See attached for an example...

In the workbook is a list of 25 properties and I want to be able to filter the data based on column B. I want to create check boxes for R1, R2, R3 and R4 and have the data filter based on which boxes I select.

For example, I select R1, R2 and R3 boxes and only the rows with those values (in column B) would appear. When I unselect the box then those rows would not appear.

Hopefully, this shines some light on my question. Let me know if you need anything else. Thanks!

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)?

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

See attached for a new schedule with ActiveX checkboxes.

Wow...your amazing!

So, to be a little clearer on one of my questions earlier...is there a way to eliminate the "Filter Me" button? That way once I select or unselect a check box it will run the filter.

Wow! money!!

Seems to work just fine. Thanks for all your help Jaslake!! I've spent over a week trying to get that to work. Many thanks!

Hey jaslake,

I need your help again! I feel so bad hitting you up so much but I really can't figure out the next part of my workbook. I tried to post a new thread last Thursday (see below for link) but no body has responded. If you get some free time would you mind taking a look? Thanks so much! your the man!

http://www.excelforum.com/excel-prog...97#post2983197

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.

This is fantastic work. Exactly what I was looking for. Thank you.

So I realize that this thread is over 4 years old since the last time someone commented on it, but I came across this while searching for an answer to a similar situation and this is the closest I have gotten to an answer. Hopefully someone that has seen this thread before is still active on this forum and can either point me in the right direction of a simpler solution or help explain how I could modify this for the need I have.

My situation is this:

I have a column on worksheet2 that I need to filter based on certain values. Those values will need to filter as a group of values, not just individually. For example: The column may contain apples, pears, cucumbers, eggplants, squash, carrots, cheese, milk, cream. What I want the autofilter to do, however, is filter these by a defined group or category denoted by a checkbox. So on worksheet1, checkbox1 would be fruit, checkbox2 would be vegetables and checkbox3 would be dairy. If the user checks one box, it filters to show only those values associated with that group. If they select two checkboxes, it would select the values for both groups.

Any suggestions or assistance would be greatly appreciated.

Hello,

Quick question:

How can this solution be modified so that instead of using the check boxes on an specific area it is used instead on each row?

In the example provided on post #13, the check boxes are at the top of the sheet. You click in the box to put the checkbox and the corresponding value will be filtered in the table below.

However, I would like to insert the checkbox (or an "X" or something) next to the row that I need filtered and only that row (or all the rows where I have the checkbox, or "X") to be shown. In other words, to do it per row (and obviously using a column where I would enter the checkbox or the "X").

I hope my scenario makes sense.

If this scenario is already done (a solution provided), can you please give me the link?

Thank you.