Help with Saving ComboBox information
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 |
All times are GMT +1. The time now is 05:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com