Hi Anyone,
I've assigned a drop down combo box where I'm trying to filter the sheet when a text is selected from the drop down box.
The validation list that I'm using is =StaffList!$I$1:$I$12 where its name is MyList.
Following is the current code that I'm using.
The above code works fine when I use a data validation list in cell E2.
What I'm trying to do is to filter the sheet from the Drop Down Combo box when a text from the list is selected.
The cell link that I'm using is E2.
I hope I have made my question clear.
Any help on this would be kindly appreciated.
I've assigned a drop down combo box where I'm trying to filter the sheet when a text is selected from the drop down box.
The validation list that I'm using is =StaffList!$I$1:$I$12 where its name is MyList.
Following is the current code that I'm using.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
If Not Intersect(Range("E2"), Target) Is Nothing Then
Application.EnableEvents = False
Range("C10").CurrentRegion.AdvancedFilter _
Action:=xlFilterInPlace, CriteriaRange:= _
Range("N1:N2"), Unique:=False
Application.EnableEvents = True
End If
End Sub
What I'm trying to do is to filter the sheet from the Drop Down Combo box when a text from the list is selected.
The cell link that I'm using is E2.
I hope I have made my question clear.
Any help on this would be kindly appreciated.