Multiple activex comboboxes on same sheet not working

[impresxy]

Hi,
I have problem to run the similar code for 3 activex comboboxes on the same sheet. These comboboxes have been linked with range name where there is index formula like below
=Data!$D$1:INDEX(Data!$D$1:$D$5000;MAX(Data!$C$1:$C$5000);1)

I create these comboboxes to be able to search the customer name when i type in any letter in the box. There was no problem when i type in the first box but when i start with
another 2 boxes, the dropdown list appears on the first box only. My dropdown code is in change event and my action code is in click event. Can anybody kindly help me out of this ?

There are 3 sets like this in the same worksheet.

Please Login or Register  to view this content.

Action code.

Please Login or Register  to view this content.

[bakerman2]

Can you post an example workbook so we have something to work with ?

[impresxy]

Hi,
Thank you for response. Here is the file.

[bakerman2]

Sorry for late response.
What if you try it like this ?

Please Login or Register  to view this content.

[impresxy]

Hi Bakerman,

Thanks for your reply. It is ok.
I have tried but it's not working. there is no dropdown appearing when i type anymore.

[bakerman2]

Try this example.

[impresxy]

Hi again,

The dropdown is working only on one combobox?

I'm thinking to change the working process to not search in comboboxes but userform.
Maybe it's easier just that the user has to trigger something to get the userform up and go.

However, I would appreciate if these 3 comboboxes can be working too?

[bakerman2]

Working on all three the moment I type in the first character.
So I really don't understand your "not working".

[impresxy]

The minute I type on the first combobox, dropdown shows on that particular combobox. But when I type on the second combobox, the dropdown still showing in the first combobox.

[bakerman2]

Can't reproduce because when I type in one and then select another first combo dropdown disappears.

[impresxy]

ok no problem, thank you very much for your time bakerman2