I have a ComboBox on my sheet and a CommandButton below it marked Save. I have it set to where the onClick for the CommandButton adds the typed in text on the ComboBox to the list on the ComboBox.

The only problem is that the information is reset every time the spreadsheet is closed and opened. Is there any way to make Excel save the data that is in the spreadsheet once it's closed ?