SolverSolve Return Values Text?

Question

VBA SolverSolve returns interger values 0 to 20. Does somebody know how I can access (and then display) the associated texts as described in the documentation?

hansvogelaar · Answer

Werner_Geiger&nbsp;
No, those descriptions are not exposed in VBA. You could create code for it yourself:
    Dim strResult As String
    Select Case Solver.SolverSolve(True)
        Case 1
            strResult = "Solver found a solution. All constraints and optimality conditions are satisfied."
        Case 2
            ...
    End Select
    MsgBox strResult

werner_geiger · Answer

OK. This is what I did already. Thanks

Forum Discussion

SolverSolve Return Values Text?

2 Replies

Resources