Close Form with VBA

[William C. Smith]

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]

Unload userformname

or

on the form's code page
Unload Me

 

[Bradley Dawson]

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]

@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.