Private Sub ComboBox1_Change() On Error Resume Next Dim XX() Dim ZZ(0) WW = ComboBox1.Value YY = Application.CountIf(Columns(6), WW & "*") If YY = 0 Then ComboBox1.List() = ZZ ReDim XX(YY - 1) K = -1 For i = 1 To Sheets("SHEET1").[A65536].End(xlUp).Row If Cells(i, 6).Value Like WW & "*" Then K = K + 1 XX(K) = Cells(i, 1).Value End If Next ComboBox1.List() = XX ComboBox1.DropDown End Sub