Autorun Macro on various cell changes

Markdiv - Jul 17, 2015 at 04:05 AM

I have 4 macros activated by 4 buttons these are macros stage2, stage3, stage4 and stage5.
If I enter values into fields D7, D8 and D9 then a variable dropdown list at D10 will update. I select from this dropdown and this selection changes cell D11 to either 1,2,3,4 or 5. Depending on the value depends which button I push to activate the macros above. A 1 does not operate a macro.
I would like to automate the above so that any changes to cells D7, D8, D9 will auto update the results based on the existing selection in D10, or if D10 is altered based on the new value in D11.
Have I explained this well enough.