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

have the combobox call the following when it changes value

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

change the ranges and field appropriately



"Scott" wrote in message
...
Does anyone know how to get an auto filter to be based on a choice in
a combo box?

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

On Jul 22, 1:03*pm, "Patrick Molloy"
wrote:
have the combobox call the following when it changes value

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

change the ranges and field appropriately

"Scott" wrote in message

...



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

- Show quoted text -