Hello world
I would like to write a VBA macro for Solver to find a minimum value for cell "CS4" by changin cell "CL10". I am using Microsoft Excel for Mac, version 16.16.9.
This is the first time I am using macros, and I've written the following macro after doing some self-study online: [INDENT]
Sub SolverMacro()
' Example Solver VBA Macro
With Worksheets("Background calculations")
SolverReset
SolverOk SetCell:="CS4", MaxMinVal:=2, ValueOf:=0, ByChange:="CL10", _
Engine:=1, EngineDesc:="GRG Nonlinear"
SolverSolve
End With
End Sub[/INDENT]
I am encountering two problems at present:
1) I have to manually deal with a popup window after a solution is found (I'd like to skip the popup window part).
2) The Solver results are not displayed to me after the calculation is finished.
I'm stuck, and not sure what I have missed.
Any help would be greatly appreciated.
Thanks for spending your time reading my post.