ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   solver dialog box in VB (https://www.excelbanter.com/excel-programming/277421-solver-dialog-box-vbulletin.html)

rd2001

solver dialog box in VB
 
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/



All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com