Run command button in another command button

[jrisebo]

I have a command button on Sheet1, Private Sub CommandButton1_Click(). On sheet2 I also have a command button, also called Private Sub CommandButton1_Click()

How do I get the button on sheet2 to also run the button on sheet1 when its pressed?

 

[My Aswer Is This]

To have several Private Sub CommandButton1_Click()
Scripts to perform the same script

Write a Module script like this:

Sub Do_This()
'Modified 11/12/2021  10:36:13 AM  EST
Dim Lastrow As Long
Lastrow = Cells(Rows.Count, "A").End(xlUp).Row + 1
Cells(Lastrow, 1).Value = "Alpha"
End Sub

Then in each Private Sub CommandButton1_Click() buttons
Put this

Call Do_This