KIM Chanthan
Member
Hi,
I have one question if excel can add 2 combo boxes or not.
I have tried to create searchable drop down list. To do that, it require to make some more formula and create some name range plus VBA code just to show all drop down when we type the word. It works perfectly fine when i create 1st combo box. However, when i do the same step for 2nd combo, seems the 2nd one have some connection with the first drop down list. I mean when i type in 2nd combo box, answer appear incorrectly in 1st combo box.
Please find attached file for more detail.
Appreciate your help.
I have one question if excel can add 2 combo boxes or not.
I have tried to create searchable drop down list. To do that, it require to make some more formula and create some name range plus VBA code just to show all drop down when we type the word. It works perfectly fine when i create 1st combo box. However, when i do the same step for 2nd combo, seems the 2nd one have some connection with the first drop down list. I mean when i type in 2nd combo box, answer appear incorrectly in 1st combo box.
Please find attached file for more detail.
Appreciate your help.
