Excel VBA - How to Run Macro when Cell Changes 

Your video's are very useful, and you have a very sweet voice. Thank you.

Thank you so much! I knew other methods but this is much cleaner :)

One really has to love that editor, sounds, red text, disabling your cursor. -.- We all do...

Hello Mam,instead of manual input in the cell....what if cell value is changed by certain formula....Then how to work in this situation?How both the tasks are completed in one go:Formula and Macro?Thanks in advance....

thank you very much. very to the point

Thanks... I Understood Intersect method because of this vlog

why the macro gets executed once i execute the code even if the test is not tru ?

thanks!!!! it was Great!!!

there is a broblem when i apply this in contents of column in a table, not a single cell... In that contents column, it's just as same as source code it self, not the data... Do you know why? and how to repair the problem??

thanx a lot :)

Thank You

Hello! Thank you for this useful macro, but I am looking for sth different, I need to run macro when field value is changed, but without clicking "enter", but when the formula inside give certain value, for example "0". For example: I have formula in cell: A3=A1*A2 and when it gives "0" macro should be run with message "Uwaga 0!". Dasz radę coś takiego opracować? :) Wielkie dzięki z góry!

Once again thank so much for sharing your knowledge

Hi, Will u explain how to crate a macro on image with another excel sheet data.

That's what I was searching Thanks A Lot

hi Frst thx for your share. One question: how to detect the change in yellow range if the value is select by validationdata ? thx for your help if you can. best regards

Why do I get the msg box when I click on the cell rather then when I change it?

thanx so mutch

This was perfect. thank you.

I can't use change event . Why ? Please

Since “Target” is a range object, is there any advantage to using “Range(Target.Address)” as your second range instead of just “Target”?

How to do this more than one in a sheet ..?

Thank you so much, been busy with this for hours!

Excellent video, to the point 👍

You saved my day, thx. =D

Thank you so much

Thank you!!! Just what I needed.

Thank you sweety

Very useful... thank you.

Great job, Thanks lots

I love your voice

helpful tutorial without long introduction and advertisement. highly appreciated, thank you

Thank you :*

Thank you!

Thank you, but maybe you should first make a test video and script and also edit your video in the way you would not make the mistakes in a tutorial... it makes you look like you do not really know what you are teaching us yourself.

Thank you