Save properties when exiting a Userform?

[embirath]

Hi everyone

Does anyone know if it is possible for a user of a userform to save properties (such as a command button's "Caption", "Backcolor", "Tag") upon exiting/closing the userform? The default properties of controls in a userform are usually set at design time, but is it possible to write it in such a way that the user can set the defaults to something other than the values that the designer chose? If so, how would I go about doing this?

Any help would be appreciated.
Thanks, and Happy Thanksgiving :-)
Emma

[dominicb]

Good evening embirath

There isn't a standard way to do this, as userforms are incapable of saving anything - they are only of use as a user friendly interface. What you could do is set a hidden sheet aside and have these values written to the sheet on exit, then when the sheet is opened these values are retrieved.

HTH

DominicB

[embirath]

That's a great idea. Thanks so much for your quick response!

Emma