![]() Function called because the Maximum Subproblems limit in the Solver Options dialog was exceeded.Function called because the Iterations limit in the Solver Options dialog was exceeded.Function called because the Max Time limit in the Solver Options dialog was exceeded.Function called (on every iteration) because the Show Iteration Results box in the Solver Options dialog was checked, or function called because the user pressed ESC to interrupt the Solver.The argument Reason is an integer value from 1 to 5: The ShowRef macro must have the signature Function name (Reason As Integer). This macro is then called, in lieu of displaying the Show Trial Solution dialog box, whenever Solver pauses for any of the reasons listed below. ![]() You can pass the name of a macro (as a string) as the ShowRef argument. False or omitted to return the results and display the Solver Results dialog box. True to return the results without displaying the Solver Results dialog box. If Solver.xlam does not appear under Available References, click Browse and open Solver.xlam in the \office14\library\Solver subfolder. In the Visual Basic Editor, with a module active, click References on the Tools menu, and then select the Solver.xlam check box under Available References. Equivalent to clicking Solve in the Solver Parameters dialog box.īefore you use this function, you must establish a reference to the Solver add-in.
0 Comments
Leave a Reply. |