Worksheet Change Event to Run a Macro

How to run a macro on worksheet change event like a change in selection in a drop-down list created using data validation. First we create a drop-down list using data validation. Now when we select a name from the drop-down list a macro is executed because we linked the target cell address with the macro. Watch the video and then study the VBA code:

Watch this video on YouTube.

Here’s the complete VBA code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = “$A$2” Then

Select Case Target.Value

Case “Harry”
Call Harry

Case “Dinesh”
Call Dinesh

Case “Rajan”
Call Rajan

Case “Laura”
Call Laura

Case “Faizal”
Call Faizal

End Select

End If
End Sub

The Target is the Range ($A$2) which has the data of names in a drop-down list. As soon as the user selects a name it triggers an action, i. e. fires up the relevant macro,

Further reading:

Worksheet Change

 

Published by

Dinesh Kumar Takyar

Welcome to exceltrainingvideos.com! My aim is to help you learn MS Excel including VBA. I always felt that a good way to learn something was to find solutions to problems in that domain. That is why I share these Excel videos with you. Mostly these are questions asked during my corporate training sessions. I've been training individuals and companies in computers since 1991. I did my B. Sc. (Vordiplom), M. Sc. (Diplom) and Ph.D. (Dr. rer. nat.) from Hamburg, Germany. The best thing about solving some of my visitor's questions is that I also gain new insights. For more Excel VBA solutions you may like to visit my YouTube channel: http://youtube.com/familycomputerclub For a structured Excel VBA training course online you can visit: https://www.youtube.com/excelvbaonline

One thought on “Worksheet Change Event to Run a Macro”

  1. Dear sir
    This is sachin shinde from mumbai.
    Your excel cha codes are very useful and it helping me a lot.specially i liked your video on emails sending via gmail using excel vba.
    Thank u very much
    Waiting for your new videos….

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.