• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 56
  • Last Modified:

How can I run Solver using VB coding without having to press ok everytime it finishes?


I have a spreadsheet that requires me to run Solver a number of times. I have written some simple VB code to perform these functions but the problem is that the message box appears each time requiring me to click OK before the code can move onto the next line. Is there any way to automatically click OK or get around that issue?

1 Solution
Rory ArchibaldCommented:
When you call SolverSolve, specify the Userfinish:=True parameter. That will skip the dialog.

pls try
Application.DisplayAlerts = False
' Your code
Application.DisplayAlerts = True

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now