Solver VBA - find minimum and display results without popup box

  • 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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!