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("A11")
.AutoFilter Field:=1 , Criteria1:=Range("combox linked cell").Value
End With
End Sub

change the ranges and field appropriately



"Scott" <(E-Mail Removed)> wrote in message
news:93f78ef4-2cdd-4a08-93b1-(E-Mail Removed)...
> 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" <patrick_mol...@hotmail.com>
wrote:
> 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" <brustk...@gmail.com> wrote in message
>
> news:93f78ef4-2cdd-4a08-93b1-(E-Mail Removed)...
>
>
>
> > 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 -