How to unload a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone

I have a form in Excel VBA and I need it to unload when I hit the cancel
button. I tried several things and none seem to work properly.

Can anyone help me?

Thanks in advance

Suzanne
 
Hi
double click the Cancel button inside the Editor and you get

Private Sub Button1_Click()

End sub

or similar. Change this to

Private Sub Button1_Click()
Unload Me
End sub

regards
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form Unload? 2
unload Me compile error 2
Unload User Form 4
Userform Queryclose and Unload problem 3
QueryClose event of a form triggering Exit event of a textbox on that form 1
How to unload a form in excel vba? 2
How to retain Userform Radio Button Memory after unload 2
Unloading a Form 2

Back
Top