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