How to unload a form in excel vba?

E

Edward

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

Thanks in advance

Edward
 
M

madbloke

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

Private Sub CommandButton1_Click()
Unload Me
End Sub
 

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

unload Me compile error 2
How to unload a form 3
Form Unload? 2
clicking cancle button still populates radio buttons, check box in 1
Excel Userform 3
Unload User Form 4
Userform: what happen to the sub who launched it? 1
QueryClose event of a form triggering Exit event of a textbox on that form 1

Top