Results 1 to 2 of 2

Thread: excel drop down list to filter worksheet

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Oct 2005
    Posts
    2

    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:
    1. Private Sub Worksheet_Change(ByVal Target As Range)
    2.      
    3. On Error Goto ws_exit:
    4.     Application.EnableEvents = False
    5.     If Target.Address = "$F$3" Then
    6.         With Target
    7.             Worksheets("Bau").Columns("C:C").AutoFilter Field:=1, Criteria1:=.Value
    8.         End With
    9.     End If
    10.      
    11. ws_exit:
    12.     Application.EnableEvents = True
    13. End Sub
    Last edited by DarReNz; Oct 27th, 2005 at 12:43 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width