Running maco from dropdown list

I am trying to incorporate the following code concept into a worksheet.  I have a dropdown list staring at Cell E1. What I'm trying to do is if I select a value from the dropdown list that a macro is ran depending on the value.

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = True

    If Not Intersect(Target, Range("E1")) Is Nothing Then
        Select Case Range("E1")
       
            Case "Testing Value 1"
                Macro1
            Case "Testing Value 2"
                Macro2 ""
            Case "Testing Value 3"
                Macro3
        End Select
    End If
    End Sub
Sub Macro1()
MsgBox "Here it is 1"
End Sub
Sub Macro2()
MsgBox "Here it is 2"
End Sub
Sub Macro3()
MsgBox "Here it is 3"
End Sub