ComboBox.Clear ...displayed values in the ComboBox dissappear

Hi everybody,

...facing again an new issue... I hope you can help me out...


I´m using two methods to clear both Combo boxes and text fields....

Formula:

Please Login or Register  to view this content.

...and it "works out"...but not that good...

When I hit the "reset" button on my form, both Combos and Text Fields are set to blank. But if I want to display again (a second time) the different options under the Combos, their selection lists are blank, empty as well...what am I doing wrong?

Thanks in advance for any help/hints

25.05.png

25.05b.png

If you clear a combobox, you clear its list entries, not simply the selection. To clear the selection, set the Listindex to -1.

Thanks rorya,

It´s a step further. i have modified the code like this:

Formula:

Please Login or Register  to view this content.

Unfortunately, this has a second unwanted effect. My ComboBoxes are dependent on each other...And now it happens that the second "child" Combo can display entries independiently from the Combo "parent". In the screenshot below, the Combo parent displays no entries, but the Com child displays independiently a set of values assigned to the first entry in the Combo parents...this shouldnt happen, since the first entry in the Combo parent was not previously selected:

25.05c.png

I have adapted the code from this tutorial...

http://www.excel-easy.com/vba/exampl...mbo-boxes.html

I forgot to mention that the set of entries displayed in the screenshot above, are those corresponding to the entry in Combo1 which last time was selected Combo parent just before making the reset.

Problem solved...the issue had to to with other part of the code (With Statements)