How do I make a command button move?

[Jack Brown]

Hey
I am trying to make a command button move a certain distance on a sheet- how do I do this?
Thanks
:bow:

[Paul_Hossler]

This is what the macro recorder gave me - you can use it as a starting point



Option Explicit
Sub Macro1()
Range("P11").Select
ActiveSheet.Shapes.Range(Array("CommandButton1")).Select
ActiveSheet.Shapes("CommandButton1").IncrementLeft -123.75
ActiveSheet.Shapes("CommandButton1").IncrementTop 1.5
Range("D29").Select
End Sub