How do I turn off the solver results dialog box

G

Guest

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.
 
D

Dana DeLouis

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. :>)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solver Function - Making it Automatic 6
Solver dialog box 1
How do I respond to a Solver Results Dialog Box from a macro? 1
How to prevent Solver Results Box from popping up? 3
Solver marco still prompts to keep solution 1
how do I turn the screen off during macro execution 2
How do I get solver to excute more than one time 11
Turning off all screen updates during a Solver routine 3

Top