Thanks very much Dana - just what I needed.

(in case anyone else nees this, you have to tick Solver in Tools, References
in the VB Editor first)

"Dana DeLouis" wrote:

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