End a procedure form a UserForm

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

I use a MsgBox with vbYesNoCancel to end a procedure if the No button is
clicked. However, the end users don't take the time to read the message and
just click Yes to get past it.

I want to use a LARGE UserForm with Yes & No command buttons to accomplish
the same thing. If the end user clicks Yes, the UserForm will unload and the
procedure will continue. What code can I put into the No command button to
end the procedure that launched the UserForm when the No button is clicked?

Thanks,

Sam
 
Unload UserForm1 'or whatever number it is.

This takes control back to the macro that showed the UserForm.
 
This might be more clear.

If you put a command button on the form:

Private Sub CommandButton1_Click()
Unload Me
End Sub

If you put a command button on a sheet:

Private Sub CommandButton1_Click()
Unload UserForm1
End Sub
 
Back
Top