Center Check boxes to cell

[ExcelNoob185]

Good morning,

Im looking to find a way to center check boxes in the cell they are placed, presently i have a check box list and id like all the check boxes to be in the center of their respective cell, is there a way to do this either with or without VBA?

My check boxes start in Column C, Cell 2 to 11, 13 to 20 & 22 to 29.

Any ideas and help would be appreciated.

Thanks in advance.

 

[Micron]

You could do this manually about 1000 times faster than anyone could code for it. If you don't see the Developer tab on the ribbon, add it. Then put the sheet in Design Mode, then click to drag. You can select (ctrl + click) and move a group if that helps. You can also use arrow keys to make minor adjustments.

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Cross posted at: Center Check boxes to cell