You originally said:
I can make selections and save them.
You would make a record of them someplace in your workbook - perhaps on a
hidden sheet.
Or in the source data, perhaps put an X in an adjacent column. Then read
back the information in a macro and make the selections in the listbox -
perhaps in the workbook_open event or the sheet activate event.
http://www.cpearson.com/excel/events.htm
Chip Pearson's page on events.
--
Regards,
Tom Ogilvy
"Kandi" wrote in message
...
Hi Tom,
Saved selections does not appear to be a feature of Excel. If it is where
do I find it?
Thanks,
Kandi
"Tom Ogilvy" wrote:
Use the saved selections to re-establish your selections in the listbox.
--
Regards,
Tom Ogilvy
"Kandi" wrote in message
...
I have a listbox on a spreadsheet (not a user form) that is populated
via
the
listfillrange property. I can make selections and save them. When I
open
the
workbook, Excel initializes the listbox object and removes my
selections.
Is
there a way to disable this "feature"?
Thanks!