Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I respond to a Solver Results Dialog Box from a macro?
I am using Solver in a macro.
When finished, Solver displays Solver Results dialog box and halts the macro. Instead of clicking the OK-button with the mouse, to resume the macro, I want to do the OK acknowledge from within the macro, thus allowing the macro to run uninterrupted from start to finish. Is this possible and if so how? |
#2
|
|||
|
|||
In article , gmk49
@discussions.microsoft.com says... I am using Solver in a macro. When finished, Solver displays Solver Results dialog box and halts the macro. Instead of clicking the OK-button with the mouse, to resume the macro, I want to do the OK acknowledge from within the macro, thus allowing the macro to run uninterrupted from start to finish. Is this possible and if so how? Check XL VBA help for the SolverSolve function, particularly the UserFinish argument. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Solver with VBA | Excel Discussion (Misc queries) | |||
Automatically Close Dialog Boxes | Excel Worksheet Functions | |||
calculating results in formulas | Excel Discussion (Misc queries) | |||
Excel's Dialog Box | Excel Discussion (Misc queries) | |||
Excel Solver Results do not show up | Excel Worksheet Functions |