Saving & Retrieivng Multi Select ListBox Values

**mini12** · 10-09-2009, 06:32 AM

Hey Guy and Dolls,

I have a problem regarding multi selection listboxes, currently I have a code that transfers the selected values from the listbox to a worksheet and then is used by formulas.

The problem is I cannot make the listbox retrieve the previously selected values when I reload the userform. Is there a solution?

The codes I am using are as follows:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Kind Regards

mini12

**royUK** · 10-09-2009, 06:46 AM

You would need to store the selected items' listindexes in a sheet

**mini12** · 10-09-2009, 09:27 AM

Hey royUK,

Thanks for replying, my mind is a blank at the mo so could you give me an example with storing the selected items' listindexes?

Kind Regards

mini12