• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Autorun macro based on changing cell value


Hi Team,

Need help with the below scenario

I have a datavalidation done on cell A1 and the datavalidation list has 3 different criteria and have if condition for each criteria

Now when the user selects Criteria 1 from the data validation list, Macro 1 should run, and then when he changes to criteria 2 macro 2 should run.

since am using my office laptop am not able to upload the sample file.

Eg if i select criteria 1, macro 1 should run

Please help.



Active Member
The one thing I've observed with the suggested macro ... the terms in E1 MUST be identical to the CASE TERMS.

In other words ... if the First Case Statement is : Case "INSERT Blank RoWs": Macro1 ..... these words INSERT Blank RoWs
be entered into Cell E1 exactly the same (spelling, case, etc),