Show the Solver Dialog Box

[GarysStudent]

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]

'https://msdn.microsoft.com/en-us/library/office/ff197237.aspx?f=255&MSPPError=-2147217396Sub 
Main()
  SolverReset
  SolverSolve UserFinish:=False
End Sub

[Aussiebear]

Have a look at Jon Peltier's website re Using Solver in VBA

[GarysStudent]

Thank you !