I have a very nice workbook/sheet that EE Pros helped me build that has three tabs. It works great until I come to a situation where I need to "uncheck" a selection.
Scenario: When you go to the "Use_Case" tab, you can click on the black box to the left and a check mark appears. This selection is then placed on line G800 in the Validation DB tab. A formula picks it up in the Use_Case_Priority Tab" so any selection ends up here.
Problem: When I uncheck a box on the "Use Case" tab, it doesn't deselect it from the list that is created in the other two tabs. That's my problem. I want to be able to select Cases and have them show up or not show up (based on selected or deselected check marks). The macro only allows for selection, not de-selection.
Workbook attached for your review. For someone with Macro skills, this should be a rather quick fix.
This is great! It works perfectly in my production model....except for one item (and I apologize I left this out)......... I have three cells to the right of Use_Case_Priority WS that need to be reset / cleared if the box is unchecked on the PMQ_Use_Case.
To see what I mean, I've included the addition. You will see 3 cases with 3 cells to the right filled out. When you deselect a case, your code works perfectly; but the three cells to the right do not clear.
I really appreciate the help.....and I'm sorry for the scope creep.