ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I turn off the solver results dialog box (https://www.excelbanter.com/excel-worksheet-functions/54465-how-do-i-turn-off-solver-results-dialog-box.html)

cripwell01

How do I turn off the solver results dialog box
 
I am running a series of optimisations using the SolverSolve function in VB.
Every time the solver works it wants me to click ok in the results dialog
box. This slows things down somewhat. Is it possible to turn off the results
box or is there some VB code that gets me past this issue.

Dana DeLouis

How do I turn off the solver results dialog box
 
Hi.

Dim Results As Long
Results = SolverSolve(UserFinish:=True)
'// Note: 0,1,2, then Solver found a solution.

Or, you can skip that and just do:

SolverSolve True

HTH. :)

--
Dana DeLouis
Win XP & Office 2003


"cripwell01" wrote in message
...
I am running a series of optimisations using the SolverSolve function in
VB.
Every time the solver works it wants me to click ok in the results dialog
box. This slows things down somewhat. Is it possible to turn off the
results
box or is there some VB code that gets me past this issue.





All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com