End a procedure form a UserForm

[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

 

[JLGWhiz]

Unload UserForm1 'or whatever number it is.

This takes control back to the macro that showed the UserForm.

 

[JLGWhiz]

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

 

[Orion Cochrane]

Try this:

Private sub cmdNo_Click
Unload UserForm
Exit Sub
End Sub