Save UserForm controls values?

[Dr.Ile]

When I reopen the file with UserForm macro I lost the controls values. How should I save and then restore them (excel reset them to their original values).

Thank you

[dominicb]

Good evening Dr.Ile

Excel doesn't provide a way to save values in a userform. You must decide whether settings should apply to all users (save the information into a hidden sheet - see my reply in this thread http://www.excelforum.com/showthread.php?t=598142) or should apply to specific users. In this instance look into the GetSewtting and SaveSetting statements in the help files.

HTH

DominicB