Autorun different macros dependent on dropdown and cell value

[Closed]
Report
-
Hello,
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. When I select from this dropdown list it changes cell D11 to either 1,2,3,4 or 5. Depending on the value at D11 it will then tell me which button to activate to run one of the above macros. IE if 1 no macro runs, if 2 macro stage2 runs, etc etc.
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.
I hope I have explained this issue well enough and any help would be valued and much appreciated. So thanking you all in advance for your time and experience.
Mark

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!