Joel,
The only way I know of to retain values in userform fields whe
the workbook is closed and then reopened is to have the textbox.valu
assigned to a worksheet cell and then when the userform is reloaded yo
have to use the initialize event procedure to read the values from th
worksheet back into each textbox. You can use a hidded worksheet s
the user won't have access to the sheet where you are temporaril
storing the textbox values
If you only want the text boxes to be able to reain their values whil
the macro is running then you can assign the textbox values to publi
variables before unloading the userform. Then when the userform i
reloaded use the initialize event procedure to fill the textboxes fro
their respective variables.

Hope this Help

--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880
View this thread: http://www.excelforum.com/showthread.php?threadid=38060