Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Solver in VBA - how to suppress results dialog box?

Status
Not open for further replies.

riskguru

Computer
Joined
Jan 28, 2002
Messages
1
Location
US
I invoke the solver add-in in a macro (Excel version 97 and 2000). After a solution is found, what is the VBA code for suppressing the results dialog box. I need to iterate this section +500 times and don't want to keep hitting the <enter> key every time. Any suggestions?

thanks
 
SolverSolve userFinish:=True will do.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top