Sheet Change Event Fails "SOMETIMES" - Dropdown Box Search

.
Mumps1

Thank you for your assistance. Love the re-worked code. Works great !

Cheers !

.
Still looking for suggestions why the macro doesn't work 100% of the time .

Thank you.

.
My apologies for not describing the error. Duh !
I am embarassed for not adhering to "Forum Posting for Dummies 101".


When selecting the Subcontractor from the drop downs, it will at first not retrieve the query. The user has to select a different Subcontractor from the dropdown, then
reselect the original choice again.

It occurs on both drop downs.

The intial design had the "active cell" remain as the drop down that was selected. That is, if the user selected B3 drop down ... after selecting a choice from B3 the focus
would remain on B3. This was changed, so after making a selection from either drop down, the focus would immediately shift to E3 .. taking the focus off of the drop downs.
(The attached file does not have this change). Intially, taking the focus off either of the drop downs worked. But then the same issue arose - again, intermittently.

It's like the program doesn't initially recognize a selection has been made from the drop down.

Any ideas ?