I have a dropdown list at c19 with 4 options. I'm attempting to trigger a msgbox to prompt the user for a secondary piece of data if option 2 is selected.

the following code snippit is what I'm attempting to modify to meet my needs but it doesn't seem to be working:

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 = "$C$19" 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 Get_WO_NUM
        Case Is = Rng.Cells(3, 1)   'Third Drop Down Item
          Call MacroC
        Case Is = Rng.Cells(4, 1)   'Fourth Drop Down Item
          Call MacroD
          
      End Select
    End If
    
End Sub
Any assistance would be appreciated. When I pick an item from the list I get a compile error sub or function not defined.