Usually you just do the following:

UserForm1.Hide

Unless Iam missing something; if this doesn't work please elaborate.

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Zoya" wrote:

I have a custom information input form with two buttons: Reset and Show
Disclosures. I need the Show Dislosures button upon clicking on it take the
data entered, populate the spreadsheet and close the form.
While I have completed the first functionality, I can't figure out how to
close the form without closing the Excel Worksheet or Workbook.
Please help.