Public sub

[Guest]

Hi:

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

Thank you

 

[Lynn Trapp]

Private Sub YourButton_Click()
YourPublicSubName(<parm list, if any>)
End Sub

 

[Guest]

Hi Lynn:

Yes, thank you! but I get:"Argument not optional"

 

[PC Datasheet]

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)