C
CAL
I have a listing of names with several columns with checkboxes (using control
toolbox). I linked the check box to the cell using a range (F:F) and then
copied this cell to the other columns in that row and edited the column
range. Then I selected all checkboxes in that row and copied down to the
rest of the rows. There are over 1,000 rows and 10 colums that need check
boxes. When I select the first checkbox, all check boxes in that column
automatically select. I don't need to link each checkbox to a specific cell,
do I? That would take forever.
toolbox). I linked the check box to the cell using a range (F:F) and then
copied this cell to the other columns in that row and edited the column
range. Then I selected all checkboxes in that row and copied down to the
rest of the rows. There are over 1,000 rows and 10 colums that need check
boxes. When I select the first checkbox, all check boxes in that column
automatically select. I don't need to link each checkbox to a specific cell,
do I? That would take forever.