Forum Discussion
Format ALL checkboxes to link to adjacent cells w/o having to Format Control all individually?
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
Thank you Riny_van_Eekelen! I think this will work. It will be faster to just do this and manually recheck them than having to individually format. Just one question. It looks like the checkboxes skip a line, but the linked cells do not, so they separate. Is there anyway I can adjust the cells to keep them next to each other? (See image below.) Thanks again for your help.
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.
Hi there , this macro is nearly ideal for what I'm trying to do but I need vary the starting location as I am creating a whole table of checkboxes, each with a linked cell (on a separate worksheet). The bit I have not worked out is how to change the starting location for each column of checkboxes.
As it is the column starts in A1 but I want to start in D4 (and then repeat in E4, F4 etc)
