View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default starting Solver with VBA

Hi.

Sub Solver_Show()
SOLVER.Main
End Sub

--
HTH :)
Dana DeLouis
Windows XP & Office 2007


"Smallweed" wrote in message
...
That works if I actually do some solving with Solver but it doesn't record
code just to display the dialog box - which is all I want it to do.

"merjet" wrote:

Turn on the macro recorder (Tools menu), use Solver manually, turn off
the recorder. The code will be in the VB Editor. Check Solver using
the menu Tools | References in the VB Editor.

Hth,
Merjet