How to save the item in the listbox

[Nader]

I use this code to add item into listbox and remove item into listbox


ListBox2.AddItem TextBox1.Text
ListBox2.ListIndex = ListBox2.ListCount - 1

ListBox2.RemoveItem ListBox2.ListIndex
ListBox2.ListIndex = ListBox2.ListCount - 1

But after I add the item the workbook doesn't save the item . How can I save the item in the list box?

[Bob Phillips]

You would need to save the listbox items on the form exit somwehere, probably in a worksheet, and then restore it next time you restart the form.

If it is just for this session, don't unload the form, hide it.

[Nader]

I don't have form the listbox is palced on the sheet1

[Bob Phillips]

Same principle.

[Nader]

I tried , but didn't success


Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Litbox2.Text
End Sub

[lucas]

Do yo want the same info to be in the listbox when you open the workbook the next time? if so see Bob's(XLD) post #2. It says that when you close the workbook to put the value in a cell somewhere and then on workbook open to repopulate your listbox from the cell..if I understand correctly.

[Nader]

I'm beginner. may you help I don't know how to do that.