Change size of the box in a Checkbox in Excel with ActiveX controls?

Question

I have this ActiveX checkbox in Excel and I want to change the size of the box.

I know I can do this if I lock it to a cell and change the cell size. Is there another way?

GSD · Accepted Answer · 2017-10-17 19:37:09Z

1

Use the Shape.ScaleHeight, Shape.ScaleWidth Methods

Sub ChangeShapeSize()
Dim Ht As Single, Wd As Single

    Ht = 1.75
    Wd = 2.75

    With Worksheets(1).Shapes("CheckBox1")
        .ScaleHeight Ht, msoFalse, msoScaleFromTopLeft
        .ScaleWidth Wd, msoFalse, msoScaleFromTopLeft
    End With

End Sub

edited Oct 17, 2017 at 19:37

answered Oct 17, 2017 at 14:18

GSD

1,2521 gold badge10 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Xtreme Over a year ago

Can you please give me an example on a checkbox?

GSD Over a year ago

I added an example to my original post, if this works for you could you please mark as answered? Thanks

Prof Over a year ago

This scales the frame of the checkbox and not the checkbox shape itself

Collectives™ on Stack Overflow

Change size of the box in a Checkbox in Excel with ActiveX controls?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related