SolverParameters behaviour different in VBA and Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I define solver options in VBA i.e. step thrue:=true to get the intermediate calculation result during debugging the program, the solver solves without stop the equations. But if I stop the program in VBA Code with a breakpoint an
insert the same paramters in the Excel solver window and activate step thru, the calculation will stop after each iteration
Does anyone knows the problem and how to solve it?
 
Don't know what to write. The code below worked as expected, i.e.,
Solver paused after each iteration. Maybe, you should post the code
you are using.

Option Explicit

Sub Macro1()
SolverReset
SolverOptions MaxTime:=100, Iterations:=100, _
Precision:=0.000001, AssumeLinear:=False, _
StepThru:=True, Estimates:=1, Derivatives:=1, _
SearchOption:=1, _
IntTolerance:=5, Scaling:=False, _
Convergence:=0.0001, AssumeNonNeg:=False
SolverOk SetCell:="$B$1", MaxMinVal:=2, ValueOf:="0", _
ByChange:="$A$1"
SolverAdd _
CellRef:="$A$1", Relation:=3, FormulaText:="0"""
SolverSolve
End Sub


--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top