How to unload a form in excel vba?

  • Thread starter Thread starter Edward
  • Start date Start date
E

Edward

What is needed in VBA to unload a form from the screen
when I click the cancel button?

Thanks in advance

Edward
 
A simple way is to put this line in your button's code:

Private Sub CommandButton1_Click()
Unload Me
End Sub
 
You must log in or register to reply here.

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

How to unload a form 3
unload Me compile error 2
Form Unload? 2
Unloading all open and hidden UserForms 3
clicking cancle button still populates radio buttons, check box in 1
QueryClose event of a form triggering Exit event of a textbox on that form 1
Excel Userform 3
ListBox / UserForm interaction 2

Back
Top