I'm trying to set up what is basically a checkbox-enabled contract builder. On a Terms sheet is a list of about 30 different contract terms and conditions (simple text entries), with a checkbox next to each one. Each checkbox is also linked to a True/False cell adjacent to each entry. The goal is to have the "checked" contract terms appear as line items on a separate Contract sheet.
Currently, I have a macro that clears and re-populates the entire Contract sheet (based on the checkbox selections on the Terms sheet). I'd like to set it up so that users can also check or un-check a particular term, and have that change immediately reflected in the Contract sheet (without having to run the macro to re-populate the entire thing).
My problem is, how do I set up an "event" macro that will run when ANY of the checkboxes is changed? I figured a Worksheet_Change macro would work (since changing a checkbox also changes its linked cell), but apparently changing a checkbox does NOT trigger the Worksheet_Change macro. I don't really want to write 30 separate CheckBox_Click macros...
So, questions:
• Apparently one can manually assign a macro to a checkbox. If I write ONE macro (called maybe AnyCheckBoxClicked), can I then assign that same macro to ALL the checkboxes?
• If the answer to the above is Yes, then how can I get the macro to know WHICH checkbox was clicked? If I could reference the cell that's linked to the checkbox, that would give me the row number of the contract term I need to work with, which would be sufficient. But I don't know to reference the "cell that's linked to the checkbox that just got changed."
Any help / suggestions would be appreciated. Thanks!
Bookmarks