Ryan,

If your workbook is large, adding userforms is not going to help.

Why don't you capture the information in separate columns and then the
result there as well? You can simulate checkboxes by using a font of Marlett
and only allowing an a or clear.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ryan" wrote in message
...
I have a workbook with several userforms. The workbook takes a person
through the steps they need to do in order to complete one job. One job
will take several days to finish. The user will not have any data to change
on the worksheets, all of their work will be done in the userforms. Since
it will take several days to complete the job, I want the users to be able
to save their work. Right now, I can't get the data which is put in the
userforms to be saved. I save the file and close it. When I reopen it, the
userforms are all blank.

I read a post on these boards about a similar problem and the solution
there was to build a dummy spreadsheet and do a circular reference sort of
thing; ie if the checkbox in the userform is checked then column A is
hidden, if Column A is hidden then on the dummy spreadsheet a value of 1 is
placed in cell A1, If the value in cell A1 is 1 then the checkbox in the
userform is checked. There are two problems with this solution and my
scenario: 1. My workbook is going to be large in size. I am trying to keep
it as small as possible to cut down on loading times and system resources
(there will be a workbook saved for each job) and 2. Not all of the changes
on my userform will create a change in the workbook. Some of them will be
yes/no questions (with option buttons) that need to be answered, but will
not affect anything.

I hope that I was clear in what I am trying to do. Getting this problem
solved will be HUGE for me. Thank you.
Ryan