Automating and adding flexibility to Excel GoalSeek and Solver?

Question

Suppose you want to compare several "What-If" scenarios with complex dependencies between the variables. You plan to use GoalSeek or Solver to find the input value that makes two outcome values the same. Goal Seek and Solver require numerical constants, entered manually, and can not use a cell reference for the target. You want to run a significant number of scenarios, and would like to automate the process as much as possible.What can you do?

Answer 1

You can execute a first scenario once by hand, and record it as a macro, which you can then assign to a Form, like a screen button. You then open the macro in VBA or the macro editor and replace the numerical values with cell references.