Exiting form removes all items from my Combo Box?

Hi All,

I am having a bit of an odd issue. When I click the Red X box at the top of my user form (which only contains 1 combobox). It clears all of the items out of my Combo Box the next time I trigger the form. When I select a valid value it autocloses fine and my code hides the form and uses the data require fine. Next time I select it works fine all the items are still in my combo box, but when I quit via (red X - Sorry can't thing of the right term for this) and re-open the form all the data is gone. The code is in 3 parts so I have included it all.

The form is triggered(shown) when I click on a cell. That all seems to work fine. So the user would click on the cell. Select a value from the drop down or exit Using form close(Red X). The user can then re-select this whenever they like. it is supposed to work like an Autofilter because I cannot use the autofilter as all items on this page are locked and protected. So I created a form to in effect emulate it.

Code Part 1 - Creating the Combo Box data (adding items) - This is called only once before control is passed to a new sheet

Please Login or Register  to view this content.

The second bit of code is the code that triggers the loading of the user form when a cell is clicked on (I removed the DIM's for size but all variables have been dimensioned

Please Login or Register  to view this content.

And Finally the code that is actually associated with the form and/or Combo Box

Please Login or Register  to view this content.

I just cannot understand why this is removing the items from the list. The combo box displays but there are no items within it?

Please help before I become totally bald!!

Thanks

Where and how do you call that first bit of code?
FYI, this:

Please Login or Register  to view this content.

is equivalent to:

Please Login or Register  to view this content.

Where and how do you call that first bit of code?
FYI, this:

Please Login or Register  to view this content.

is equivalent to:

Please Login or Register  to view this content.

Your problem is the fact that the form is being unloaded, not hidden, and your setup code is never run again to put the values back. To ensure it gets hidden use:

Please Login or Register  to view this content.