Check Boxes in Excel

Question

Hello!.

I'm using the "Check Box" function form the Developer Tab ( My version of excel doesn't have the new Quick Version from the "Insert" tab. )

So the Sheet has 2800 Rows with 12 Columns.

So that's 33600 Cells potentially.

When I link the Check box to the Cell. its defaults with the $ function e.g. $A$1, and so all the cells would be linked to this one..

Is there a way that allows me to Copy the Check boxes across the sheet.. So that I wouldn't have to go and manually assign each checkbox to the cell for calculation purposes. ? I can then use the COUNTIF function for the true Values ( Checked )

And then get the Checkbox to be centralised to the cells / position etc.

Many Thanks

Duncan

Answer 1

In theory, it's possible to write a macro that creates the check boxes and links them to the appropriate cells.

But I fear that creating and using over 30,000 check boxes would have a negative impact on performance and would be a nightmare to manage.

I'd simply enter an "x" or something like that in the cells, and use the COUNTA function to count non-blank cells.