Close Form with VBA
 

Is there a VBA command that will close a userform, the equivalent of the
user clicking the close button on the form title line?

Close Form with VBA
 

Unload userformname

or

on the form's code page
Unload Me

--
Patrick Molloy
Microsoft Excel MVP
----------------------------------
"William C. Smith" <wcsmithx*xieee.org wrote in message
.. .
Is there a VBA command that will close a userform, the equivalent of the
user clicking the close button on the form title line?

Close Form with VBA
 

You may also want to try the Hide method. It keeps the form in memory, so
entries do not get erased, but removes the form from view.

UserForm1.Hide

"William C. Smith" <wcsmithx*xieee.org wrote in message
.. .
Is there a VBA command that will close a userform, the equivalent of the
user clicking the close button on the form title line?

Close Form with VBA
 

"Patrick Molloy" wrote in news:#QMUmaybDHA.2932
@tk2msftngp13.phx.gbl:

Thanks for the help. Unload userformname works fine. I did not try Unload
Me on the form's code page, but I could not find any reference to Unload Me
in VBA help.

Again, thanks.

Unload userformname

or

on the form's code page
Unload Me