ActiveX ListBoxes not saving data

[Demon4231]

I have an excel sheet with 4 ActiveX listboxes, I have 4 buttons for each list to add an item to each of the lists. The data is added to the list and is displayed properly, but when I save then re-open the file the lists are empty. I tested this with a new file with 1 list box and 1 button that adds an item to the list and it does the same thing. Is there a reason the lists are blank? I know I can have the list be loaded from a separate sheet every time the file is open but that completely defeats the purpose of having the listbox in the first place.

Here is my test listbox code:

Please Login or Register  to view this content.

[JapanDave]

Paste this in the workbook module

Please Login or Register  to view this content.

[Demon4231]

Sarcasm?

In my other Excel sheet the user enters two values, and each value goes into one of the columns so I can't do that.

[royUK]

The values must be stored somewhere e.g. on a sheet. You can't just add them to the listBox & expect them to stay there

[Leith Ross]

Hello Demon4321,

If the only information the ListBox contains is from these buttons why does it need to be saved?
If the ListBox contains other information, where is it loaded from?
If the buttons are always adding the same data to the ListBox, how do you prevent duplicates or do you?

[JapanDave]

No, actually it wasn't.

And what is the point of using a button to load a listbox? Why not use dynamic ranges and refer to them?