I have a userform that has several values that can be changed by the user. What I would like to do is have the default properties save once the form is exited. (with a save and close button)
Currently, each time I change the values and close the form, the default values are displayed when opening the form next time. (as I would expect!)
I'd like to change those default values and properties, and I would have thought it would be straight forward. I CAN do it by linking it to reference cell on a worksheet, but that's not what I am looking for.
I want to initialize a variable when the form loads, based on the current values of certain objects, and don't want the variable tied to a cell value. But I don't want the user to have to change them each time the form is loaded.
I hope I have explained this well enough!
Thanks in advance.
Bookmarks