excel drop down list to filter worksheet
Hi, how do i code for selecting in a drop down list instead of typing into a cell ? Thanks
VB Code:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Goto ws_exit:
Application.EnableEvents = False
If Target.Address = "$F$3" Then
With Target
Worksheets("Bau").Columns("C:C").AutoFilter Field:=1, Criteria1:=.Value
End With
End If
ws_exit:
Application.EnableEvents = True
End Sub
Re: excel drop down list to filter worksheet
The Dropdownlist your talking about is the AutoFilter dropdown? If you want to select an item you should filter on a single criteria, easier.