I have collaborated a multipage on a userform that is used as a sort of
wizard for a design calculations program, but it is also the single
interface with the spreadsheet (if the wizard closes, Excel closes, and
the spreadsheet cannot be modified manually). I have the userform
automatically display upon opening the excel file, and each modified
file is saved by the quote number. However, whenever a file is opened
in the future, I want it so that the userform still has all of the
values in the text boxes, and that all of the corresponding check boxes
that were selected (and modified comboboxes, etc) are the same as when
the userform was last closed (for that saved file). How would I go
about doing this? If this is unclear, please let me know and I will
see if I can further clarify.

Thanks in advance!

Trace


--
biodieselbenz
------------------------------------------------------------------------
biodieselbenz's Profile: http://www.excelforum.com/member.php...o&userid=24958
View this thread: http://www.excelforum.com/showthread...hreadid=384875

Have the form write the values of the controls on the form into a hidden
sheet when the user unloads the form. Then you can write some code that
initializes the form with those values when it is re-opened.
--
HTH...

Jim Thomlinson


"biodieselbenz" wrote:


I have collaborated a multipage on a userform that is used as a sort of
wizard for a design calculations program, but it is also the single
interface with the spreadsheet (if the wizard closes, Excel closes, and
the spreadsheet cannot be modified manually). I have the userform
automatically display upon opening the excel file, and each modified
file is saved by the quote number. However, whenever a file is opened
in the future, I want it so that the userform still has all of the
values in the text boxes, and that all of the corresponding check boxes
that were selected (and modified comboboxes, etc) are the same as when
the userform was last closed (for that saved file). How would I go
about doing this? If this is unclear, please let me know and I will
see if I can further clarify.

Thanks in advance!

Trace


--
biodieselbenz
------------------------------------------------------------------------
biodieselbenz's Profile: http://www.excelforum.com/member.php...o&userid=24958
View this thread: http://www.excelforum.com/showthread...hreadid=384875

You would have to save that information somewhere, such as on a hidden
worksheet, and have some way of knowing which item is being selected, some
sort of Id. When you open the form again, you would then look it up.

--
HTH

Bob Phillips

"biodieselbenz"
wrote in message
news:biodieselbenz.1rr73u_1120662708.6207@excelfor um-nospam.com...

I have collaborated a multipage on a userform that is used as a sort of
wizard for a design calculations program, but it is also the single
interface with the spreadsheet (if the wizard closes, Excel closes, and
the spreadsheet cannot be modified manually). I have the userform
automatically display upon opening the excel file, and each modified
file is saved by the quote number. However, whenever a file is opened
in the future, I want it so that the userform still has all of the
values in the text boxes, and that all of the corresponding check boxes
that were selected (and modified comboboxes, etc) are the same as when
the userform was last closed (for that saved file). How would I go
about doing this? If this is unclear, please let me know and I will
see if I can further clarify.

Thanks in advance!

Trace


--
biodieselbenz
------------------------------------------------------------------------
biodieselbenz's Profile:
http://www.excelforum.com/member.php...o&userid=24958
View this thread: http://www.excelforum.com/showthread...hreadid=384875