How to implement a Cancel button on a userform?

Question

I have a UserForm with a cancel button.

Sub DialogTest()
    MyForm.Show
End Sub

Private Sub CancelButton_Click()
    Unload Me
    End
End Sub

I also tried MyForm.Hide, End by itself, cmdExit_Click.

The cancel button does not close the dialog nor does it cause the debugger to come up.

i'm not really sure what you're asking... i provided the exact location of Unload Me in my code sample above... it's in Private Sub CancelButton_Click() — b747fp
– b747fp, Commented Jun 9, 2018 at 4:20
By where I meant Sheet, Module, or UserForm. I was only able to Unload the UserForm when the code was pasted in the UserForm (Which I accessed by double-clicking on the cancel-button from VBA) — urdearboy
– urdearboy, Commented Jun 9, 2018 at 4:34

urdearboy · Accepted Answer · 2018-06-09 04:37:40Z

5

I was only able to replicate your issue when the Unload Me Sub was pasted in a Worksheet or Module. When the Sub is in the Userform, it works fine.

Here, the code is pasted in a module and does not close the Userform

Instead, from VBE, double click on your UserForm, then double click on your Cancel Button.

Then paste the code here

edited Jun 9, 2018 at 4:37

answered Jun 9, 2018 at 4:33

urdearboy

14.6k6 gold badges35 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

b747fp Over a year ago

perfect. thanks. im not sure why that is not made clear on any of the articles i googled all day. makes sense now

Collectives™ on Stack Overflow

How to implement a Cancel button on a userform?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related