Saving Information on Userforms
 

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

Saving Information on Userforms
 

Ryan,

If it must be userforms, it must, and if we can gain you some big kudos,
let's give it a try. It might take a few iterations, but we should be able
to help.

Starting off, I'll ask a few opening shots.

The data that is to be entered in the userform, what is it for? What do the
forms do, and what happens to the data that is entered?

What does the worksheet data look like, and what gets updated and how?

If it takes several days to complete a set of forms, does that mean that
there is only one active at any one time, that is the next cannot be started
until this is completed.

If I read it correctly, you want to save whatever has been entered to date,
and next time you open the workbook, you want it to detect that, re-open the
same forms, and re-populate the forms. Is that a fair summary?

--

HTH

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

"Ryan" wrote in message
...
Bob,

I have already built several userforms and would like to find a way to
save the information there. If no one on this board is able to help me then
I will have to scrap all of the userforms and create individual sheets for
each userform which is not at all what I want to do from an ease of use
standpoint for the users.

Ryan

Saving Information on Userforms
 

Bob

Your summary sounds about right. As for some of your questions, I can't answer them. It's not that I won't answer them it's that I don't know. My boss has it all in his head how the data will connect and what different things will do. He has yet to put it into any form. I can tell you that we are a mortgage company and the workbook is a way to try and automate the process to make it easier/save time/get from start to finish quicker. He has just given me the rough drafts of how each page in the workbook will look and what he wants on the userforms. All I know at this point is that he will want the data to be saved on the userforms

The workbook pages (for the most part) only have command buttons that open up the different Userforms. There will be a logical process for the users to follow, but at some points they will be able to move ahead (Again, if I knew more I would tell you, but at this point I do not know how the data will interact)

Sorry about being vague, but it is vague to me too. If it is more helpful to know what the processes will do, I will have to post in the future when that information is given to me

I want tto be able to enter data into the userforms (which have textboxes, comboboxes, option buttons, and checkboxes) close the userforms, save the workbook, close the workbbok. Then when I re-open the workbook and click on one of the command buttons to show a userform, the data is the same from the last time I worked in the workbook

I hope this helps clear up your questions. If you need more clarification, I will be happy to provide it for you

Ryan

Saving Information on Userforms
 

Hello Ryan,

I tried a few things, unsuccessfully, to achieve the desired result in an
elegant way but I don't think you can. I think the only viable method is to
have an 'in-progress' sheet that has a column for every possible entry for
your user forms (maybe a diffeerent sheet for each form if they are
complicated) and then when the user is done for the day write the data to
this sheet and then load it in again the next time the user opens the
workbook. Bob had a very good question when he asked if more than one
project will be going on at a time. If so, I recommend separate workbooks
for each project if possible.

HTH, Greg

"Ryan" wrote in message
...
Bob,

I have already built several userforms and would like to find a way to
save the information there. If no one on this board is able to help me then
I will have to scrap all of the userforms and create individual sheets for
each userform which is not at all what I want to do from an ease of use
standpoint for the users.

Ryan