Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver dialog box
I am trying to use the solver function within a macro and I want the macro to
end not with the "solve" button in the solve dialog box, but with the solution itself in the worksheet. Is it possible to do that? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver dialog box
Try something like this:
Sub Macro1() SolverOk SetCell:="$A$2", MaxMinVal:=3, ValueOf:="0", ByChange:="$A$1" SolverSolve UserFinish:=True End Sub This is an easy example of setting A2 to zero by updating A1. The UserFinish statement avoids the last dialog box that asks if you want to keep the result. By the way. VBA Help is not very helpful on this topic. Better see: http://support.microsoft.com/kb/843304#5 -- Gary''s Student - gsnu200780 "gtoffoli" wrote: I am trying to use the solver function within a macro and I want the macro to end not with the "solve" button in the solve dialog box, but with the solution itself in the worksheet. Is it possible to do that? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to record the EXCEL Solver Parameters Dialog Box? | Excel Discussion (Misc queries) | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
How do I turn off the solver results dialog box | Excel Worksheet Functions | |||
How do I respond to a Solver Results Dialog Box from a macro? | Excel Discussion (Misc queries) | |||
solver dialog box in VB | Excel Programming |