Checkboxes not allowing me to select individually

%3CLINGO-SUB%20id%3D%22lingo-sub-1316149%22%20slang%3D%22en-US%22%3ECheckboxes%20not%20allowing%20me%20to%20select%20individually%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1316149%22%20slang%3D%22en-US%22%3E%3CP%3ESo%2C%20I%20am%20creating%20a%20spreadsheet%20for%20work%20purposes%20and%20I%20have%20included%20two%20columns%20that%20require%20a%20checkbox%20in%20each%20cell.%20I%20have%20now%20added%20over%20200%20checkboxes%20to%20cover%20enough%20cells%20for%20the%20information%20required%2C%20but%20when%20I%20tested%20a%20box%2C%20one%20column%20is%20fine%20and%20allows%20me%20to%20check%20individual%20boxes%2C%20but%20the%20second%20column%20checks%20all%20of%20them%20once%20one%20has%20been%20selected%20and%20the%20words%20'true'%20and%20'false'%20appear%20in%20the%20cell%20behind%20the%20checkbox.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20stop%20this!%3F%20been%20playing%20around%20with%20it%20for%20quite%20some%20time%20now%20and%20I%20haven't%20been%20successful%20as%20of%20yet!%20HELP!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1316149%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1316237%22%20slang%3D%22en-US%22%3ERe%3A%20Checkboxes%20not%20allowing%20me%20to%20select%20individually%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1316237%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F626439%22%20target%3D%22_blank%22%3E%40LHollands%3C%2FA%3E%26nbsp%3BI%20wonder%20how%20you%20created%20the%20checkboxes%20in%20the%20first%20column.%20Did%20you%20create%20them%20one-by-one%3F%20And%20how%20did%20you%20create%20the%20ones%20in%20the%20second%20column%3F%3C%2FP%3E%3CP%3EI%20suspect%2C%20you%20created%20one%20box%2C%20linked%20it%20to%20a%20cell%20and%20then%20just%20copied%20it%20200%20times.%20Then%20all%20of%20these%20are%20linked%20to%20the%20same%20%22result%22-cell.%20TRUE%20means%20checked%2C%20FALSE%20means%20unchecked.%20(Un)check%20one%20and%20all%20get%20(un)checked%20at%20the%20same%20time.%20You%20need%20to%20go%20in%20to%20each%20and%20every%20box%20and%20allocate%20a%20single%20linked%20cell%20for%20every%20single%20box.%20Or%2C%20create%20them%20with%20a%20small%20macro.%20But%20that%20requires%20some%20knowledge%20of%20Visual%20Basic.%20Are%20you%20comfortable%20with%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

So, I am creating a spreadsheet for work purposes and I have included two columns that require a checkbox in each cell. I have now added over 200 checkboxes to cover enough cells for the information required, but when I tested a box, one column is fine and allows me to check individual boxes, but the second column checks all of them once one has been selected and the words 'true' and 'false' appear in the cell behind the checkbox. 

 

How do I stop this!? been playing around with it for quite some time now and I haven't been successful as of yet! HELP!

1 Reply
Highlighted

@LHollands I wonder how you created the checkboxes in the first column. Did you create them one-by-one? And how did you create the ones in the second column?

I suspect, you created one box, linked it to a cell and then just copied it 200 times. Then all of these are linked to the same "result"-cell. TRUE means checked, FALSE means unchecked. (Un)check one and all get (un)checked at the same time. You need to go in to each and every box and allocate a single linked cell for every single box. Or, create them with a small macro. But that requires some knowledge of Visual Basic. Are you comfortable with that?