Autofilter on a combo box

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

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
 
Thanks! I set my combobox change command to call this function and it
works out well.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoFilter Slow problem 1
combo box to be used in Macro 6
Use userform to select autofilter requirements 0
How to fill a combo box with choice from another combo box 7
Having trouble with combo boxes. 11
Prevent edit on combo box? 1
combo box 2
Combo Box value is null 2

Back
Top