solver dialog box in VB

R

rd2001

I'm running solver in a macro, and my problem is that if the solver
can't find a solution because it times out, I don't know how to have
the macro select on the "continue" option in the dialog box (without
any input from the user). Basically I need to know how to have the
macro respond to the dialog box without stopping from running.

Can anyone help me with this?

thanks
 

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

Excel 2007: Creating a macro that will run Solver. 0
Excel 2007: Help creating a macro that will run Solver? 3
Excel 2007: Help creating a macro that will run Solver? 0
Solver programming questions 8
Solver dialog box 1
Need Help with Macro Security 1
Another solver question 1
Link a text box based on drop down box with four options MS Word 365 0

Top