preserving info in a form

[boom2boom]

I have a problem with a simple program. I made some forms within an Excel sheet; they pop-up when the user clicks embedded checkboxes. The forms contain a series of questions using checkboxes and a few text boxes.

It works fine, but none of the information in the forms is saved when the Excel file is closed (i.e., if I save the file, close Excel, and re-open the file, the forms which were filled out are blank when opened).

These are electronic survey forms, so I need these forms to remain as is unless a user goes into them and makes alterations. Is there a bit of code or a command that I can use for each form or object to preserve my data between file uses?

The obvious answer is the one I'm looking for. I'm just learning VB. Any input would be appreciated.

[Si_the_geek]

I think the easiest way is to save the data into a hidden worksheet