Abort function for a Cancel button

Markus1989 · Oct 25th 2019

So, I have a large userform that includes a Cancel button. I would like an abort function included. For example a vbyes/no "Are you sure you want to cancel?" I experimented with a few things but when I run the Privare Sub CommandButton1_Click I loose the userform. Any ideas?

Thanks in advance!

**royUK** · Oct 25th 2019

try adapting this

Code

Option Explicit


Private Sub CommandButton1_Click()


  Select Case MsgBox("Are you sure you want to cancel?", vbYesNo)
    Case vbNo: MsgBox "You clicked No"
    Case vbYes: MsgBox "Aborting"
    End Select


End Sub

Display More

Markus1989 · Oct 25th 2019

Works perfect! Thank you.

Mark

**royUK** · Oct 26th 2019

Pleased to help

Abort function for a Cancel button

Participate now!

Share