Using autofilter top#10 on advanced filter

[Waimea]

Hi, I am using the advanced filter with two criteria to sort a list.

However, I want to use top #10 or top #25 items using auto filter.

Is it possible to use top #10 with advanced filter and/or can I use auto filter on the list that I sorted using the advanced filter?

 

[Waimea]

I think I got the auto filter to work, however, is it possible to select which value to sort on using an activex combobox?

 

[Waimea]

Sub FilterRowsTop5()
ActiveSheet.Range("A1").AutoFilter Field:=4, Criteria1:="5", Operator:=xlTop10Items
End Sub

I want to use Criteria2:=ComboBox1.Value and/or Autofilter Field:=ComboBox1.Value but I can't get it to work.

 

[Waimea]

Any suggestions on how to use a combobox to select which field to autofilter top#5 on??

 

[Waimea]

Anyone? I am still trying to figure out how to use autofilter top#5 with an activex combobox.