Pre-load listbox selections only loading 1 selection

[skysurfer]

Hi,

I've created a simple listbox on a userform that loads the prior selections from the last time the userform was used (thanks Leith Ross!). Problem is that not all the prior selections are pre-loaded; only one is.

I think the problem is the userform activation code triggers the listbox change code that contains a line that clears the listbox content, because when I remark it out, the pre-selections load perfectly (but then the listbox will not function properly). I've bolded that line in the code below, and the file itself is also included.

Please Login or Register  to view this content.

Leith's original posting is here: http://www.excelforum.com/excel-prog...-in-range.html

Thanks,

Lawrence

[skysurfer]

Good morning,

Just bumping this up for the early birds.

~L

[Leith Ross]

Hello Lawrence,

I am working on your problem. If I understand correctly what you want to do with this code, it can be simplified using a few tricks. I'll post the corrected workbook later on.

[skysurfer]

Thanks!

Lawrence