I found the code below and tried to alter it for my use but was unsuccessful. Could someone please alter it or provide new code for me?
The code below runs 1 of 3 macros based on the item chosen from a drop down list. My needs are to run 1 macro ("SortCourse") no matter what item is chosen from the drop down list.
Many thanks in advance. Cindy
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Addx As String
Dim Rng As Range
Addx = Target.Validation.Formula1
Set Rng = Range(Right(Addx, Len(Addx) - 1))
If Target.Address = "$E$1" Then
Select Case Target.Value
Case Is = Rng.Cells(1, 1) 'First Drop Down Item
Call MacroA
Case Is = Rng.Cells(2, 1) 'Second Drop Down Item
Call MacroB
Case Is = Rng.Cells(3, 1) 'Third Drop Down Item
Call MacroC
End Select
End If
End Sub
Bookmarks