Posted 8 September 2017, 1:03 pm EST
I have a simple list of items in a spreadsheet, with description, price and a check box.
I am attempting to have it run a routine, CalculateTotals, to sum up the prices of selected items each time the user clicks on a rows check mark to pick it.
I can't get any event to register when the check mark is checked on and off. Every event I have tried does not calculate the sum unless I leave the cell by clicking on another cell.
What am I missing here? What event fires (and please tell me there is one) when a check box is checked on or off?