hmmm... by "every time the spreadsheet is closed and opened", do yo
mean closing and reopening the Workbook? maybe you can save the item
in the combobox to a hidden sheet (xlVeryHidden). then, you can jus
fetch the data from that sheet and put them to your combobox when you
workbook opens... :)

SystemHack Wrote:
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 type
in text on the ComboBox to the list on the ComboBox.

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

--
T-®e
-----------------------------------------------------------------------
T-®ex's Profile: http://www.excelforum.com/member.php...fo&userid=2657
View this thread: http://www.excelforum.com/showthread.php?threadid=39886