How does Solversolve Control Macro
 

Solver manipulates input variables to make a target
function in a cell achieve a maximum, minumum or specified
value.

However, if the target value is to be generated by a 500
line VB Visual Basic program, how does one get the Solver
to drive the VB program? Is this possible? I've tried
ShowRef:="Validator II", which is the start of the VB
program, but the system just twitches a few times and
exits. Setting PassThru:= does not change anything.

How does Solversolve Control Macro
 

http://support.microsoft.com/support...ver/solver.asp
Creating Visual Basic Macros that Use Microsoft Excel Solver

perhaps that will shed some light.

--
Regards,
Tom Ogilvy

"Dacvid Cardner" wrote in message
...
Solver manipulates input variables to make a target
function in a cell achieve a maximum, minumum or specified
value.

However, if the target value is to be generated by a 500
line VB Visual Basic program, how does one get the Solver
to drive the VB program? Is this possible? I've tried
ShowRef:="Validator II", which is the start of the VB
program, but the system just twitches a few times and
exits. Setting PassThru:= does not change anything.