i created a very complex program that runs a lot of different macros. in the initial userform there is an options commandbutton that leads to an new userform. in this options userform there are many different textboxes with default information filled in. if the user wishes to change the default information, he/she can, but when excel is closed, and then reopened, the textboxes return to the default. i already have a commandbutton that returns all the textboxes to default. how can i add a commandbutton that saves the users input into the textboxes each time excel is opened and that macro is run? i was thinking maybe i can save the excel file with this commandbutton, but would this save the textbox inputs of the user?? thanks for any help in advance.