How to clear a form from the screen

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

Guest

Hi,

I need to have a cancel button on my form that removes it from the screen. I
don't always want to click the x in the corner.

Is this possible?

Thanks in Advance
Gordon
 
Hi

Add a button on your userform with a macro with this line

Unload Me

And in the properties of the button set Cancel to True
 
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 remove stuff that appears when I click on the windows button on the bottom left of my screen? 2
Removing The Quit/X Button On An Userform 7
Form with no Cancel option 8
Calling Button click event from Form initialise event? 2
Position Userform In Cells Portion of Excel Only 1
Clear a range of cells given 2 Cell addresses 4
VBA Clear Screen 1
Add the command "Clear All Filters" to a Command Button in Access 2010? 0

Back
Top