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.

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

[stevebriz]

at the end of the code :

 unload Userform1

Thank you so much! I just got fixated on the "closing" and didn't think that
it could be so simple.
Thank you again!

"Michael" wrote:

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