Check box form control - alignment format

[FengXue]

I've been having trouble centering a check box form control on my excel sheet. I see under the Shape Format tab there is an Align option under the Arrange group; however, when clicking this option, the align center option is not available to use. Is the only option available to center a form control to manually move the check box to the approximate center of designated cell B23?

 

[Micron]

I would think you'd have to go to Developer tab >Design Mode and select the control/shape first.

 

[Skyybot]

I don't see a Checkbox in your example. I see a Note and a ComboBox (or ListBox). To center a CheckBox just Select the Cell, select the Insert tab in the Ribbon, and then click Check Box.

 

[Micron]

Look at the image of the sheet, not of the dropped down ribbon control. There is a checkbox there.

 

[Skyybot]

I would think you'd have to go to Developer tab >Design Mode and select the control/shape first.

Oh dang! I barely saw that thing looking for it.

 

[Skyybot]

This is as close as I could get. Paste this codes in the Sheet code module that the CheckBox is on. Select the cell that the CheckBox is "in" and run this Subroutine.

Option Explicit

Sub CenterCheckbox()
Dim cell As Range, cBox As Shape, i As Integer
Set cell = Selection
Set cBox = Me.Shapes("Check Box 1") ' Change to your CheckBox name
With cBox
    .DrawingObject.Caption = ""
    .Height = cell.Height
    .Width = cell.Width
    .Top = cell.Top
    .Left = cell.Left + cell.Width / 3
End With

End Sub