ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help with Saving ComboBox information (https://www.excelbanter.com/excel-programming/338254-help-saving-combobox-information.html)

SystemHack

Help with Saving ComboBox information
 

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 ?


--
SystemHack
------------------------------------------------------------------------
SystemHack's Profile: http://www.excelforum.com/member.php...o&userid=26614
View this thread: http://www.excelforum.com/showthread...hreadid=398864



All times are GMT +1. The time now is 10:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com