Change Values in cell from Check box?

[Ebes1099]

I have a list of Items that I have a Macro setup to grab info on but I want the user to be able to select a subset of these items based on some characteristics.

Right now I have a "flag" in Column A that I've just hard-coded in as a 0 or 1. Each item has a Color, Size, Type. The list of items is around 700 right now, and there can be anywhere from 10-15 unique values in each of these categories, Color, Size, Types. I was hoping I could have the flag in column A be dependent on what the user selects. My thoughts were to have Checkboxes for the three categories. Essentially it would be, do you want to select a block of items based on color and you'd check the colors of the items you wanted. Maybe you check Red, Blue and Brown. If those were the only boxes checked, every item that was Red, Blue or Brown would have a 1 in Column A and the rest would have 0's. Now say the user wants to select by Color and Size. So they check the boxes of Orange, Green, Large and X-Large. Now only the Orange Large, Orange X-Large, Green Large, Green X-Large items have a 1 in Column A and the rest have 0's. So there are going to be some Orange and Green plans that have 0's.

What is my best approach for dynamically changing the values in Column A?

 

[combo]

You have some options to limit/customise selection.
Forms controls: radio buttons + frame, checkbox and combo box, they have linked cell property and associated list in case of combo box. In linked cell a selection is stored (either TRUE/FALSE or selected item number).
Data validation with list + input and error messages: selection from allowed range of data.
Both work with named ranges for lists/linked cells that can be in other worksheet in this case.

combo