Advice Required Using Solver from within VBA

[seanphayre]

How do I over-ride the pop up box to accept the solver solution everytime. Setting up the case and solving works as I wish. however, everytime I iterate there is a need to interact by manually accepting or rejecting the solution provided. Can this be circumvented? [sig][/sig]

 

[karlf]

This is an old thread, but I am interested in an answer. Can anyone help?

Karl

 

[tab245]

Hi!

I am not a big expert, but I think, this should work:

' Do not display the Solver Results dialog box.
SolverSolve UserFinish:=True

' Finish and keep the final results.
SolverFinish KeepFinal:=1

Tanya