List Box Clearing on Open

[Tarball]

I have a worksheet with a series of listboxes (with the list option =1 to allow multiselection). These boxes are loaded dynamically (not using the linkedcell method).

I can load the boxes just fine, and make selections I need. However, even after the workbook is saved, when I close it, then reopen it, the list boxes are cleared. I can actually see the data for a split second in the listboxes before they are cleared.

I have made sure that I am not using a clear method when the worksheet is opened and I do not have a sheet event to clear them either.

Any ideas as to why list boxes would automatically clear on open of a workbook? Thanks for the help and ideas.

I cannot post the workbook as it contains sensitive account information.

[Leith Ross]

Hello Tarball,

What event are you using to load them?

[Tarball]

Here is the code. On the sheet, there are 3 regions, each region has 5 list boxes (I know - not the best design but Im stuck with it from a user perspective). Each region has a command button used to load the respective boxes. There is a configuration that allows the user to open the windows file picker to locate the workbook from which to load the accounts. All of this functionality works just fine.

The problem arises when I save the sheet. Regardless of whether I check or dont check items all of the list boxes clear. As I mentioned before I can see the data for a split second just after the sheet opens.

Please Login or Register  to view this content.

[Tarball]

Any ideas?

[d3hartm2]

I'm having the same problem with an application I'm working on. Not sure why the listboxes are clearing themselves...

[d3hartm2]

I got mine to work. Tarball, did you leave the "ListFillRange" property blank? As soon as I set that property to a range containing the strings I wanted to populate the ListBox with, the data remains in place after saving and opening the workbook. When I left it blank, the ListBox cleared after opening, just as it was doing for you.

[erdeimij]

The problem that I am having is that I am inputting information into a list box from a series of input boxes. When I close the spreadsheet and reopen it all of my entries in the list box are gone. Anyone have any idea how to fix this?