View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dacvid Cardner Dacvid Cardner is offline
external usenet poster
 
Posts: 1
Default 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.