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

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?

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?

"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