G Guest Sep 23, 2004 #1 Hi: What is the easiest way to run a public sub from a control button? Thank you
L Lynn Trapp Sep 23, 2004 #2 Private Sub YourButton_Click() YourPublicSubName(<parm list, if any>) End Sub
P PC Datasheet Sep 23, 2004 #4 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)
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)
