Excel Controls

[GLENEE]

I have 2 controls on a spreadsheet. The first is a textbox the second is a listbox using multi select. When i exit excel and reopen, the value in the textbox is retained but the value is lost in the listbox, am i missing something obvious?

 

[combo]

You can use one cell (LinkedCell) to store list selection, this does not work for multi and extended selections.

combo

 

[GLENEE]

That's a pity. I can store the multi select using code but i was hoping to avoid using code/macros in the spreadsheet. I guess I'll have to use individual check boxes and group them togethet to 'look' like a list box. Thanks anyway.

 

[combo]

Why not reserve a part of the workbook or names (can be hidden) to store settings when the workbook is saved or selection changed and recreate them when the workbook is being opened?

combo