How to close a form window?

A

An

To the form object,"Hide" method makes the window disapear,
"unload" method removes it from memory.Is there a method
corresponding to the "Close" button?
 
C

Chip Pearson

You can use "me.close" method to close the current form

No, you can't. A UserForm doesn't have a Close method. You can
either Hide the form, which will keep it in memory so you can
access the values of its controls, or Unload the form, which will
remove it from memory.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
G

Grch

No, you can't. A UserForm doesn't have a Close method. You can either Hide
the form, which will keep it in memory so you can access the values of its
controls, or Unload the form, which will remove it from memory.
Click to expand...

in Excel U can HIDE a form
in Access U can CLOSE a form

t.
 
C

Chip Pearson

It would have been helpful if the original poster had stated the
application in which he is working.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top