Run Macro If Cell Value Changes / Excel VBA Tutorial

In this video, I am showing you how to run a VBA macro whenever the value within a specific cell changes.

I hope this helps!

[cogwheelLearning]

Awesome tutorial Nik! It would be great if you could zoom in a little so the cells appear bigger. Pretty hard to see on mobile this way. ✌️

[valentinaledesma]

Thanks !! That was very useful, although, I suggest to zoom to your code in following videos, it was a litle hard to read .-.

[iamcurios]

Good idea, bt u might want to make what u r typing is visible to us. No one can see such a small screen even in 1080p resolution!!

[KleanthisSkoulikaris]

Wow, things are getting serious now. We started adding "swag" to VBA! 😆

[mirrormefashion]

Finally found the video I need but I can't see a single thing you're doing 😫😫. Very unfortunate.

[norbster]

Using MS Office 365 for Mac. Followed all your steps and the macro did not trigger. Macro is part of a module and the cell change event trigger is under the sheet where the cell value changes. The macro runs with no problem when manually triggered, but it seems like excel does not recognise the cell value change. Ideas? Thanks!

[barryc]

Zoom, can’t read the code because it’s too small

[johanlompieslombard]

Good day. Thanks for this excellent site where I can get meaningful solutions.
However, when I type the routine that call the macro, exactly like in the example, except for variables, I get an error on the following line:
If Not Intersect(target.Range("O2")) Is Nothing Then

Here is the error message:
Compile Error:
Argument not optional

[rubenpedersen]

Hi Nik!
Very useful video. But one thing I've been thinking about and not clear out yet;
How do I write the code when I want the individual cells in row "c" to keep the data they receive from, for example, cell "a1" My problem is that "a1" is updated against live data every 60 minutes. At the next update, I want to keep the data and store new data in the cell below. I have created a script for a new cell every 60 minutes. But has not solved this with the fact that the stored cells are not changed by live update.
Well I hope you have an idea :)

[MovingFwrd]

Can you disregard download link example xls

[mahadevtengse]

Need help with macros because my data range always change sometimes its 1000 rows/coloums or somtime its more than that or sometime less

[edwardrambanpinem]

Hallo Sir, i have excel data come from scanning Barcode that content HTTPS link. Now i klik every single line of data to insert Barcode content to Google Form. All data at A colom. How to automate it when new line data come. Thks

[ProjeAdam.]

bro I want to work macro when changed now time cell but not working

[tanujsharma]

I need a code in vba that pastes a range from sheet 2 to sheet 3 automatically when any value in that range changes
Please help.

[DJSimNRecords]

Als je iets meer inzoomt kan ik het beter zien!

[GilmoreAntalan]

why would you not make the screen bigger. only you can see what you are doing.

[kamrulzoha]

For your code
We need 4 Glasses 🤓
Make something which we can read 🤣
Already some ppl like me
Don't want to use big screen mobiles and your code very hard to read .
Hhhh