CheckBox position

[sapka]

Hello,
How can I change the position of CheckBox (Forms one) with VBA?
P. S. I am not talking about UserForms.

 

[mikerickson]

Its pretty much the same on a sheet or a userform, set the .Left and .Top properties of the controls.

The thing about Forms Checkboxes is that they are members of the sheet's Shapes collection.

With ActiveSheet.Shapes("Check Box 1")
    .Top = 100
    .Left = 150
End With

 

[kpark91]

right click on the checkbox and go to properties.
You'll see list of properties of the checkbox and you will see properties such as Top, Width, Height, and Left.

You can adjust those by simply

With Shapes("YourCheckBoxName")
    .Top = 135
    .Left = 135
    .Height= 30
    .Width = 20
End With