In excel i have various cells that have a drop down e.g. A29, C29, and i want to run a different set of macros depending on the range,

Question

In excel i have various cells that have a drop down e.g. A29, C29, and i want to run a different set of macros depending on the range,

Brian Vagg 0

In excel i have various cells that have a drop down e.g. A29, C29, E29, G29, I29, A31, C31, E31 G31, I31 etc and i want to run a different set of macros depending on the range,For A29 it is one particular type, C29 a different set of types

In the below how do I add if the target is If Target.Address = "$A$29", and E29 and I 29 and so on

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$C$29" Then

    Select Case Target.Value

        Case "16.4 Grasim"

            Call Grasim_164

        Case "16.9 Grasim"

            Call Grasim_169

        Case Else

            MsgBox "No macro defined for: " & Target.Value, vbExclamation

    End Select

 On Error Resume Next

    Application.Run Target.Value

    On Error GoTo 0

End If
```End Select

```vba
 On Error Resume Next

    Application.Run Target.Value

    On Error GoTo 0

End If
```End Sub

1 answer

Your answer

Answer 1

Thomas4-N 2,660 Microsoft External Staff Moderator

Hello Brian Vagg, welcome to Microsoft Q&A forum.

I understand you want to run macros when specific dropdown cells change without repeating multiple If Target.Address = ... checks. You can simplify your code by using the Intersect method to check if the changed cell is in your allowed list.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.CountLarge > 1 Then Exit Sub
    ' One check for all allowed cells
    If Intersect(Target, Range("A29,C29,E29,G29,I29,A31,C31,E31,G31,I31")) Is Nothing Then Exit Sub
    Application.EnableEvents = False
    Select Case Target.Value
.....

Let me know if you have any further questions. Warm regards,

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Thomas4-N 2,660 Reputation points Microsoft External Staff Moderator

2025-10-25T10:41:59.4833333+00:00

Hi Brian Vagg,Just checking in to see if the above information was helpful. If you have any further updates on this issue, please feel free to post back.

If you think my reply is helpful to you, please remember to mark it as Accepted Answer. Warm thanks.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Brian Vagg 0 Reputation points

2025-10-26T04:05:41.35+00:00

also adding that say if I select option 1 in dropdown A29 and it runs that macro, i want to be able to then select C29 option 2 and it will run associated macro and c29 option 3 and runs macro then A29 option 6 and so on

Share via

In excel i have various cells that have a drop down e.g. A29, C29, and i want to run a different set of macros depending on the range,

1 answer

Your answer