I have developed a spreadsheet with 78 checkboxes on it. I have linked each
checkbox to the cell underneath it. For ease of use for the end-user, I have
a Worksheet_Change code, and the keyboard user can simply enter 1/0, T/F,
True/False or a space to change the checkbox. The Worksheet_Change code
looks at the entry and adjusts the checkbox accordingly. Of course, these
checkboxes also have an effect on other parts of the spreadsheet. Everything
works fine for the keyboard user.

For the mouse-user, though, clicking the checkbox changes the linked-cell
entry, but does not trigger the Worksheet_Change event. Can I assign the
same macro to each checkbox, which will, in turn, edit the linked cell of the
box which was just checked? If so, my question is -- how do I determine the
checkbox number which was just checked, without writing code for each
checkbox? The cell edit (cell.value = cell.value) would then trigger the
Worksheet_Change code, which I know is working correctly.
--
TIA, Brad E.