Saving settings on UserForm

[Richard]

I have finished a userform, which has many drop downs and
checkboxes. The workbook the userform sits in will be
saved for each project. Is there a way of stopping the
userform resetting when the workbook is accessed in the
future once the project has started? At the moment, if
someone decides first there are ten units on the project
and then change their mind to 5, the boxes are hidden and
the values changed to false to enable the caluculations
behind. I want the values retained regardless of what is
clicked.

Also, i am using the PrintForm control, but is there an
equivalent to save the form?

Thanks in advance

Richard

 

[Bob Phillips]

Hi Richard,

You need to store the values somewhere. You could either save them in the
registry (using GetSetting and SaveSetting, although you will need to manage
different workbook), or save them in the workbook, on a hidden sheet say.

--

HTH

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