Hide_Unhide using Chek Box

Hi, I want to create Check boxes to hide rows.
There are 3 Check boxes. Design, Sales, Customer

What I want to do is if "D" is typed on Column A in any of the rows, only show rows with "D" in column A if Design Checkbox is clicked. Else, hide all rows with D.

If "S" is typed on Column A in any of the rows, only show rows with "S" in column A if Sales Checkbox or Design Check box is clicked. Else hide all rows with S.

If "C" is typed on Column A in any of the rows, show rowns with "C" in column A is Customers, Sales or Design check box is clicked. Else hide all rows with C.

So prettymuch, i want the macro to scan all lines in Column A to see whether the row is D,S, or C and perform hide row as discussed before.

Any help is much appriciated.

thankyou

Hi,
it seems that you would never hide a "C" row unless there was no single checkbox selected or have I missed something??
jmac

hi jmac,

Thats right. you would only hide C if none of the boxes are clicked.

Thanks

hi tharindudk

are multiple options allowed??

jmac

Hi.
No multiple options aren't allowed
THANKS

tharindudk.xlsm

Hi tharindudk,

Take a look at the attached, I didnt do any checkboxes and instead simply allowed cell A1 to be the value of the checkbox.

I am not sure I have your requirements 100% implemented but it should be a start for you

and I am 100% sure there are many more clever ways to resolve the problem

jmac

Hi Jmac,

I managed to do it in a different way. Thankyou for your help