I have some cells that change due to calculations via the worksheet_calculate sub. What happens is that a checkbox is check, which changes a cell from false to true. Once 3 checkboxes in a certain range are all checked (true), another cell changes.

How do I trigger an event to happen when these cells change? I have tried using the worksheet_change sub, but it doesn't work.

Any advice would e very much appreciated