Triggering a macro based on the selection made by different dropdown lists

  • Hi iam not able to write a macro which triggers the macro based on the selection made from the dropdown list

  • Possibly using the worksheet change event...

    1. Private Sub Worksheet_Change(ByVal Target As Range)
    2. 'Assumes dropdown list in cell A1 and "ABC" is selected to run the macro
    3. If Target.Address = "$A$1" Then
    4. If Target.Value = "ABC" Then Call Macro1
    5. End If
    6. End Sub

    If I've been helpful, let me know. If I haven't, let me know that too.