Independent Dropdown list in Userform Comobobox cause Find Next/Previous Error

[Faridwahidi]

Hi,

I need to use dependent drop down list in my Combobox. However, when I click the button for 2nd time the fields not display.

I have run single step cross the button "F8" and found ".Clear" may cause the problem after 2 time click. i.e. 1s time, click on find 1st record, then 2nd time click on find Last record, the data not display.

The problem may solve if I am not use Dependent drop-down list and put all in UserForm_Initialize()

Please Login or Register  to view this content.

[nilem]

Hi Faridwahidi,
maybe so

Please Login or Register  to view this content.

and also try so

Please Login or Register  to view this content.

[Faridwahidi]

Hi nilem,

Thanks A lot