excel drop down list to filter worksheet

[DarReNz]

Hi, how do i code for selecting in a drop down list instead of typing into a cell ? Thanks

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

[RobDog888]

The Dropdownlist your talking about is the AutoFilter dropdown? If you want to select an item you should filter on a single criteria, easier.