Forum Discussion
Solved
Format ALL checkboxes to link to adjacent cells w/o having to Format Control all individually?
There are 96 spreadsheets. Each spreadsheet has 60 checkboxes. I need to find all of the boxes that were checked and calculate various things from there. But first step's first, link each checkbox wi...
My example sized the checkboxes at 30 pixels high, starting at (0,0) i.e. top left of the sheet, and with a row height of 30 as well. Play around a little with the parameters to make it match your requirements.
You ask how to automate the creation of checkboxes and linking cells to these checkboxes. The topic below includes a macro i created. It creates checkboxes (how many do you want?), names them and links each of them to a cell. Perhaps this gets you started. You need to scroll down a bit, though.
https://techcommunity.microsoft.com/t5/excel/copying-a-check-box-to-other-cells/m-p/1091496