Currently i have this code
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = True ' <-- just for tests
If Not Intersect(Target, Range("C1")) Is Nothing Then
Select Case Target.Value
Case "Expander 1 eff"
CopyIncreaseRecord
Case "Expander 2 eff"
CopyIncreaseRecord
Case "Pump eff"
CopyIncreaseRecord
Case "Net Power"
CopyIncreaseRecordNetPower
End Select
End If
End Sub
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
Bookmarks