Close Form with VBA

  • Thread starter Thread starter William C. Smith
  • Start date Start date
W

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?
 
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
 
@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.
 
Back
Top