S S P P Member Thursday at 5:43 PM #1 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
Belleke Well-Known Member Friday at 3:34 PM #2 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??
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 S P P Member Friday at 4:42 PM #3 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
Belleke Well-Known Member Saturday at 4:18 PM #4 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
S S P P Member Yesterday at 2:50 AM #5 Yes Same as the userform The filter that is not working If the same letter is in a line sequence, only one letter appears.
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 S P P Member Today at 2:18 AM #6 '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
'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