Search in combobox product column of table1

[S P P]

The combobox cannot list repeated products

Listbox will list the combobox search

 

[Belleke]

No clear.
Do you search on product, date or unit?
What do you mean by combobox cannot list repeated products, what is de difference between product A in unit 3 and product A in unit 7 and product A in unit 47??

 

[S P P]

I made one like this
The filter that is not working well

 

[Belleke]

Do you mean something like this?
Select product in combobox and see result in listbox.

 

[S P P]

Yes
Same as the userform
The filter that is not working
If the same letter is in a line sequence, only one letter appears.

 

[S P P]

'How to change this VBA

Set Ws = Worksheets(1)

'For a Table

For i = 2 To Ws.Range("B" & Rows.Count).End(xlUp).Row

'Second column

If Ws.Cells(i, "C").Value = ComboBox1 Then