PDA

View Full Version : [SOLVED] Show the Solver Dialog Box



GarysStudent
09-10-2016, 04:54 PM
I am try to find out how to show the Solver dialog box. For example:


Sub dural()
Application.Dialogs(xlDialogGoalSeek).Show
End Sub

brings up the Goal Seek dialog, but:


Sub dural()
Application.Dialogs(xlDialogSolver).Show
End Sub


just throws an error.

Kenneth Hobs
09-10-2016, 06:40 PM
'https://msdn.microsoft.com/en-us/library/office/ff197237.aspx?f=255&MSPPError=-2147217396Sub
Main()
SolverReset
SolverSolve UserFinish:=False
End Sub

Aussiebear
09-10-2016, 06:49 PM
Have a look at Jon Peltier's website re Using Solver in VBA

GarysStudent
09-11-2016, 01:08 PM
Thank you !