Redispay multiselect listbox items after saving and closing excelf

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a multiselect listbox on an Excel worksheet. A command button is
created to populate this listbox

Private Sub CommandButton1_Click()
ListBox1.AddItem ("test1")
ListBox1.AddItem ("test2")
End Sub

After saving and closing the excel file, I re-open the worksheet. I can see
the values "test1" and "test2" very briefly before the listbox is wiped
clean. How do I prevent this?? I want to be able to see the values that I
saved previous in the listbox.

Thanks.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

move item in multiselect listbox 1
inconsistent dir() behavior 1
Listbox Output to Individual Listboxes 1
Blank item in listbox, how to remove 3
Problem with multiselect listbox items selection 2
Listbox displaying incorrectly on opening worksheet 3
move item from one listbox to another listbox 6
Listbox populated with Sheet Names to Hiughlight Activesheet 2

Back
Top