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.
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.