Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trouble with Solver | Excel Discussion (Misc queries) | |||
How do I respond to a Solver Results Dialog Box from a macro? | Excel Discussion (Misc queries) | |||
Using Solver with VBA | Excel Discussion (Misc queries) | |||
calculating results in formulas | Excel Discussion (Misc queries) | |||
Excel Solver Results do not show up | Excel Worksheet Functions |