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