Run Macro When Specific Cell Value Changes | Drop-Down List Changes | Value Changes Within a Range

[@ZippyDeluxe]

I've searched several times for this solution over the past year or so. I wasted so much time trying other tips that simply DID. NOT. WORK. But this dude NAILED it. Yeah, baby!!!!!!!

[@mustavogaia2655]

I think we need a macro to "thumbs up" when a new video is uploaded on this channel. Good work as ever.

[@PFunk-kt9gc]

I find your videos very informative and to the point. No long preamble.

[@brunogarcia7221]

Congratulations four your video! It becomes so easy to do what you teach in your tutorials

[@IvanCortinas_ES]

A very interesting case with drop down, but no change in the selection. Thank you Chester!

[@matheww9944]

Great content, It took me a while to work out how to do multiple ranges on the same page but all the same great work :)

[@nguyenthanhtu1983]

Great! Ereka :D Thanks!

[@michaeliverson8464]

Very cool. I don't know when I'd use it, but nice to know it's available.

[@stefankapanski3210]

It's a great video. I have a question for the first example. I would like to run a macro when the result of a formula is changed/calculated.

[@alializadeh8195]

Thanks

[@ChesterTugwell]

Welcome

[@Mr.Snow12]

Can I use target address on more than 1 cell? I have a long code that's slowing down my worksheet. So I'm wondering if I can use the target address for a cell, then go to the specific code and exit sub instead of running through the whole code..

[@avelonudas58]

Hi Sir!, May you also share what VBA code I can add on this to run the macro in protected worksheet? Thank you so much!

[@karlheyes18]

Hi, thanks for the video. this works fine if the value of the cell changes- macro runs. However, I would like the macro to run even if the value doesn’t change, I.e. upon pressing enter I want to move to a specific cell irrespective of whether the value changes or not. please help.

[@zoranlazic6900]

This was helpful. Thank you! I have 20 lines of code and problem was that code is triggered with every selection of cell (because I used that event). Now it runs only when specific cell is changed.👍

[@cecilleforce2576]

How to get them to work in windows 11 if the file is saved on one drive. Thanks

[@stevereed5776]

Would the macro run if there was a spilled array on top of it?

[@anujmehta2468]

I am facing some syntax error after pasting the code. Please tell me what mistake I could be making?

[@justinsmith3079]

I have come across many videos that suggest the same route but none that solve my problem. I have multiple worksheets and I need the code to run for all of them. It can't be only for a specific worksheet. I even need it to run if I copy one of the sheets it is supposed to work on and create a new sheet from it in the same workbook. The number of worksheets is indeterminate and malleable, so copying the code for each worksheet is not a viable option.

[@ludodegroote3783]

A message box, yea nice, but what about a more complicated macro, not just a msg box?