How to execute a macro when a cell value changes?

[sylvainsyl20]

Hi everyone,

I got some help coming up with the following code.

The code works, only when I get into VBA window and I Run it (Tools/Macro/RUN)

How can I force it to automatically run when the content of cell B6 changes?

Maybe I didn't input the macro as it should be, I went in VBA, right click on the sheet that I want, insert, Module.

I really need help on this one

Here is the code

Please Login or Register  to view this content.

[mehmetcik]

right click on the sheet name at the bottom of excel and select view code.

Paste this code into the window that opens

Please Login or Register  to view this content.

[sylvainsyl20]

Thanks for this one,

When I follow the instruction, I get the place to input the code, but there are already something in the Private Sub Worksheet_Change(ByVal Target As Range)

Please advise as how I can get around this one.

Thanks

[mehmetcik]

Try something like:-

Please Login or Register  to view this content.

[sylvainsyl20]

Thank you very much for the help on this one, it just not automatically run when I change the value in B6.

I think I will have to attach the code to a button to make it run manually.

Any suggestions will still be welcome