Filtering

[max1565]

Is it possible to filter with the criteria being from an listbox? For instance say there is a column A on worksheet1 with a list of names where a specific name may occur many times.

How would you use the name the user selects as the filtering criteria.

Thanks

 

[JPMontreal]

Hi,

Use this macro

Sub FilterCriteria()

Selection.AutoFilter
Selection.AutoFilter Field:=2, Criteria1:=ActiveCell
End Sub


Jean-Paul
Montreal
jp@solutionsvba.com
mtljp2@sympatico.ca

 

[JPMontreal]

Hi,
Sorry , if it’s column A, it should be like that:
Use this macro

Sub FilterCriteria()

Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=ActiveCell
End Sub


Jean-Paul
Montreal
jp@solutionsvba.com
mtljp2@sympatico.ca