Run Subroutine located in Sheet1 from a command button in a form?

[EssKayKay]

Hello,
I’m trying to run a subroutine(s) from a command button on a form.

Originally I was running the Subs directly from buttons on the worksheet. However, I am getting too many buttons so I decided to create a separate form with all the buttons. Then there is only one button on the worksheet that opens my form (frmControlCenter) with all the other buttons. Most of these are working fine. However, there are a couple that return errors. The one Sub in particular I am working on is called cmdRESET_Click() where I am attempting to run to previous worksheet button's sub called cmdClearALL_Click.

Here is my code on the form that I am attempting to run cmdClearALL_Click():
Not sure if it matters but I should note, Sheet1 is named "Amoritze".

Private Sub cmdRESET_Click()
   Application.Run "Sheet1.ClearALL_Click"
End Sub

Here is the error and highlighted coding problem:

Any suggestions would be appreciated.

Thanks for viewing,
Steve K.

 

[NdNoviceHlp]

Hi Steve. I suggest moving your sheet subs to modules and making them public. They would no longer be command button codes (ie. Public Sub ClearAll). You can then simply "Call ClearALL" for example to run the sub from the form. HTH. Dave

 

[EssKayKay]

Hi Steve. I suggest moving your sheet subs to modules and making them public. They would no longer be command button codes (ie. Public Sub ClearAll). You can then simply "Call ClearALL" for example to run the sub from the form. HTH. Dave

Thank you Dave, that helped. I still am having a few minor issues but I think I'm going in the right direction - I'll keep at it. Any other problems, I'm sure I'll be back.

Just a question here - based on your suggestion, I assume I should just move all the code in a Module or two and make all the Subs Public?
I think you can tell I really don't know much about this - but I try. . .

Thanks again,
Steve K.

 

[NdNoviceHlp]

You are welcome. As fa as moving all your subs to a module and making them public, it depends on how you use the subs. Public subs in modules are available to the entire project ie. they can be called from sheet code or form code. Form code is only available to the form. Thanks for posting your outcome. Dave