View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Listbox initialized on workbook load

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!