i want to control two drop down lists to tell which macro to be run automatically

Currently i have this code

Please Login or Register  to view this content.

under the Sheet5 (Graph1) view code.

presently i'm using one drop down in cell C1 to tell which macro to run automatically when i select an option in cell C1,

now i want to have two drop downs in cell C1 & in cell C2, for example if C1 is selected "Expander 2 eff" and C2 is selected "Cycle eff" i want macro Expander2effvsCycleeff to run if C1 is selected "Expander 2 eff" and C2 is selected "Massflowrate" i want macro Expander2effvsMassflowrate to run.

pls help, thanks in advance

i tried AI but it is not giving me the selection in two cells to be met

Add second level to your selection tree, like:

Please Login or Register  to view this content.

You could use not if ... elseif .... else but Select .... case ....case endselect construction for the second level