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.
Private Sub ComboBox22_Change()
ComboBox22.ListFillRange = "DropDownList2"
ActiveSheet.ComboBox22.DropDown
End Sub
Action code.
Private Sub ComboBox22_Click()
'Customer1
i = Range("A2").Value
m = Application.Match(i, Sheets("Data").Range("A:A"), 0)
Range("A3").Value = Sheets("Data").Range("K" & m).Value

End Sub