Public sub

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi:

What is the easiest way to run a public sub from a control
button?

Thank you
 
Private Sub YourButton_Click()
YourPublicSubName(<parm list, if any>)
End Sub
 
In your Public Sub, if you have this:
Public Sub(MyArgument As String)
the argument is not optional.

If you want it to be optional, use this:
Public Sub(Optional MyArgument As String)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Anyone Else Facing Public Folder Migration Errors in Exchange? 0
Exit ALL Subs? 1
Outlook Private Sub Application_Startup()....What if it be public 1
Shape Arrays VBA 0
public procedure 5
call sub from other module 3
User Defined Type Not Defined 0
How do I call a procedure in Main form from sub-form? 2

Back
Top