Creating a macro which presses a button containing a recorded macro

[petros89]

Is there any way I can create a button which repeatedly click another
button containing a macro? If so, please help me as I need it for my
school work.

 

[Bernie Deitrick]

Remove the Private keyword from in front of the commandbutton_click event, and use a sub like

Sub TryNow()
Dim i As Integer
For i = 1 To 10
Sheet1.CommandButton1_Click
Next i
End Sub

 

[Tom Ogilvy]

Just repeatedly call the same macro that clicking the button causes to run.

 

[kerem.erdogan]

add a button in excel worksheet
right click and select view code

Private Sub CommandButton1_Click()
Call macro1
End Sub


petros89 yazdi: