J
Janis
I have 3 option buttons on a form that run 3 different macro modules. The
cancel button works if you run the form and decide to cancel, however if you
are running one of the option buttons and then decided to cancel it doesn't.
How do I get it to cancel in between process 1, process 2 or process 3? Is
there a kill button? Here is the cancel button and the done button that I
use once the 3 processes are finished.
----cancel button----
Private Sub cmdCancel_Click()
Unload Me
End Sub
------Done with 3 processes button-------
Private Sub cmdDone_Click()
If Fprocess1 = True And Fprocess2 = True And Fprocess3 = True Then
Unload Me
Else
MsgBox " All options must be completed before closing"
End If
End Sub
thanks,
cancel button works if you run the form and decide to cancel, however if you
are running one of the option buttons and then decided to cancel it doesn't.
How do I get it to cancel in between process 1, process 2 or process 3? Is
there a kill button? Here is the cancel button and the done button that I
use once the 3 processes are finished.
----cancel button----
Private Sub cmdCancel_Click()
Unload Me
End Sub
------Done with 3 processes button-------
Private Sub cmdDone_Click()
If Fprocess1 = True And Fprocess2 = True And Fprocess3 = True Then
Unload Me
Else
MsgBox " All options must be completed before closing"
End If
End Sub
thanks,