Hi guys, based on Kenneth Hobson on my previous problem really help me alot. But my codes have a little problem on filtering the data. When i try to find "Test" without select the comboBox, the result will filter well. But the problem is now, when i want to find "Test" but with category in the combo box the result only shows 2 data while it suppose to get 6 data with the word "Test" in "E-Professional" category.
[ATTACH=CONFIG]73879[/ATTACH][ATTACH=CONFIG]73880[/ATTACH]
Here is the codes for the selection based on category
Code
If cbo_cat.ListIndex = -1 Then 'nothing selected based on comboBox (cbo_cat)
Set aCell = Range("A4:A" & Range("A" & Rows.Count).End(xlUp).Row).Find(what:=SearchString, LookIn:=xlValues, _
LookAt:=xlPart)
Else
ActiveSheet.UsedRange.AutoFilter 5, cbo_cat.Value
Set aCell = Range("A4:A" & Range("A" & Rows.Count).End(xlUp).Row).Find(what:=SearchString, LookIn:=xlValues, _
LookAt:=xlPart)
Application.ScreenUpdating = True
End If
Display More