• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search in combobox product column of table1

S P P

Member
The combobox cannot list repeated products

Listbox will list the combobox search
 

Attachments

  • Search in combobox product column of table1.xlsm
    21.3 KB · Views: 5
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??
 
I made one like this
The filter that is not working well
 

Attachments

  • Search in combobox product column of table1.0.xlsm
    26.3 KB · Views: 5
Do you mean something like this?
Select product in combobox and see result in listbox.
 

Attachments

  • Search in combobox product column of table1.xlsm
    32.7 KB · Views: 5
'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
 
Back
Top