Hi Helpers !

I want to program a simple macro that gives increased value down the column.
i wrote following code:

Private Sub CommandButton1_Click()

Sub SSHT1()

Dim x As Integer

For x = 1 To 10
Cells(9, 5).Value = x - 1
Next x
End Sub

i don't know
-how to inset command button on excel worksheet ?
-how to connect that macro with this command button so that the macro runs
- how to make it run and see the results?

Thanks