Wrox Programmer Forums
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 12th, 2007, 05:45 AM
Registered User
Join Date: Apr 2007
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Solver Results Auto Accept

I am writing a Macro using the Solver tool to solve a number of problems in the same manner.

After it has solved each case the pop up box entitled "Solver Results" appears.

What is the code to Keep Solver Solution and automatically select the OK button to avoid having to click the OK button for every case it has solved?

Old July 15th, 2007, 07:30 AM
Registered User
Join Date: Jul 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

That is very much easy.
You just need to copy below code to replace the final row "SolverSolve"

SolverSolve UserFinish:=True
SolverFinish KeepFinal:=1


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sudoku solver aehb Visual C++ 3 November 12th, 2011 07:41 AM
Increment By Range & Output Solver Result ibrahim ahmad Excel VBA 0 April 30th, 2008 10:16 PM
Edit Query Results in Results Grid druid2112 SQL Server 2005 1 June 28th, 2007 08:49 AM
Use function Solver of Excel in VB.NET 2003 pliroforikarios VB.NET 2002/2003 Basics 0 November 27th, 2005 03:37 PM
How to accept apostrophe entered by user karjagis Access ASP 0 April 6th, 2004 06:21 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.