Sep 25 2021 08:14 AM
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?
Sep 25 2021 09:23 AM
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