Autofilter on a combo box

[Scott]

Does anyone know how to get an auto filter to be based on a choice in
a combo box?

 

[Patrick Molloy]

have the combobox call the following when it changes value

Sub SetFilter()
With Range("A11")
.AutoFilter Field:=1 , Criteria1:=Range("combox linked cell").Value
End With
End Sub

change the ranges and field appropriately

 

[Scott]

Thanks! I set my combobox change command to call this function and it
works out well.