Wrong combobox drops down

Dear all,

I have 2 activex comboboxes in the same sheet, when I start filling the first one, it drops down as it should and according to what I type the list shortens to what is available. So far so good.
Then when I start using the second combobox still the first one drops down instead of the one I'm using.
It is the same problem if I start with the second one and and go to the first, the second one drops down again.
So the one I first use will always drop down again.
I tried several things but no solution so far.

Thanks in advance for any help,
Regards,
Rudi

Dave,

There is already some code in it and some jumps from one sheet to another.
Is there a possibility to send the whole excel file, there are no secrets in it.

Dave,

sorry for late reply but I was unexpectedly out for business.
I hope the file is ataached. In the sheet "Transactie" you will find 2 activex comboboxes, start typing somthing in the first one, select the item you want and press enter.
Now start typing in the next combobox and you will see that the first one drops don again instead of the one you are using.

Regards,
Rudi

Sorry for the late entry,
I removed the code in the comboboxes - in the change event, you had added a dropdown command. After I removed those the combos worked. Also, an aside, but if you would like a more stable method of receiving data from a combo try the keydown event and use the If KeyCode = vbKeyReturn. The change event is less stable for conveying info. Additionally, you can add error handlers to assure that you are receiving the correct format: String, for example.
Anyway, sorry again for the interrupt and good luck.
Happy days,
Shawn