How to duplicate form control's checkbox in Excel 2007 with "TRUE" "FALSE" text
- by EverWondeR
For example I made check box in A1 with "=$B$1"
So now, when I click it the "TRUE", "FALSE" text appears
depending if check box is checked or not.
The problem starts when I want to duplicate those two to
more rows. Now every check box makes the B1 text to change, not
the one it represents as in check box A1 should change B1 text,
check box in cell A2 should change B2 text and so on, but now
all check boxes change the same B1 text.
Is there any workaround?