Using a ListBox with ListStyleOption

[Rurick]

I have created a UserForm in VBA Excel that has a ListBox with the ListStyleOption selected. The MultiSelectMulti option is activated.
Whenever I close the user form or workbook and then reopen, all the previous selections are gone. Is there a way to retain selections made in listbox?


Thanks.

 

[My Aswer Is This]

If you close the UserForm like this you will retain the selections:

Private Sub CommandButton1_Click()
Me.Hide
End Sub

Now these selections will not be saved when you close the Workbook.

I have created a UserForm in VBA Excel that has a ListBox with the ListStyleOption selected. The MultiSelectMulti option is activated.
Whenever I close the user form or workbook and then reopen, all the previous selections are gone. Is there a way to retain selections made in listbox?


Thanks.