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!!!!!!!
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.👍
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.
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..
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.
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!!!!!!!
I find your videos very informative and to the point. No long preamble.
Congratulations four your video! It becomes so easy to do what you teach in your tutorials
I think we need a macro to "thumbs up" when a new video is uploaded on this channel. Good work as ever.
A very interesting case with drop down, but no change in the selection. Thank you Chester!
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 :)
Great! Ereka :D Thanks!
Very cool. I don't know when I'd use it, but nice to know it's available.
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.👍
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.
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.
I am facing some syntax error after pasting the code. Please tell me what mistake I could be making?
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!
Thanks
Welcome
Would the macro run if there was a spilled array on top of it?
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..
How to get them to work in windows 11 if the file is saved on one drive. Thanks
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.
A message box, yea nice, but what about a more complicated macro, not just a msg box?