To run a macro when values of the cells modified?

[tms_]

Hi,

I would need to get a macro running every time when the document is modified.

Please Login or Register  to view this content.

This code would work, but the problem is that the macro edits the cells, and therefore it ends up running over and over again...

Thanks!

[royUK]

It would probably be more helpful if we saw your code

[tms_]

This is a simplified example (the actual code runs also a macro which changes the y-axis scales of charts located on their own sheets...).

When I edit the value of a cell, excel gets stuck prompting "hi!" over and over again...

"ThisWorkbook":

Please Login or Register  to view this content.

and

"Module 1":

Please Login or Register  to view this content.

[jasoncw]

Try this:

Please Login or Register  to view this content.

HTH

Jason

[tms_]

Try this:

Please Login or Register  to view this content.

HTH

Jason

That seems to work, thanks!

However, I realized that the macro should also automatically run when the y-axis scale of a chart is manually adjusted (format axis). Is there a way to carry this out?

Edit: I would also need to distinguish the cases, where the user has manually changed the y-axis scale, and where edited the values of a cell...

Thanks for your time.