Macro run depending on cell value

Yes, this should be straightforward. I take it you want the relevant procedure to be called when M3 is changed? If yes, then does M3 contain a formula (it would change when the worksheet is calculated) or a constant (it would change when someone types in a new value)?

Hi,

Right click on the sheet's tab > View code.

Copy and paste in this procedure:

Please Login or Register  to view this content.

Hi Colin thanks for that. Something isn't quite right though as the macro it calls for seems to freeze, or get stuck (it continually loops the first part by the looks of things). Is there a conflict somewhere?

My macro 3 code is as follows

Please Login or Register  to view this content.

The actions you are performing in that macro are causing the calculate event to be raised: your code is calling itself recursively. To get around this you have to temporarily set Application.EnableEvents to False - but you must ensure it gets set back to True before the procedure ends.

I've tidied up the code and incorporated this for you:

Please Login or Register  to view this content.

You may well find that you have to perform a similar exercise with Macro4.