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
Bookmarks