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




Reply With Quote