Solver is tightly tied to worksheet cells. You can set up and run
Solver from VBA, but you would still have to load and change workseet
cells. A VBA function that is called from a worksheet can only return a
value, it cannot modify its environment (in particular it cannot change
cell values), and thus cannot use Solver. A VBA function could use
solver when called from a Sub instead of a worksheet cell.

Jerry

JParshley wrote:

I would like to call the Solver add-in as a function from a cell and feed it
the input parameters on the main Solver dialog box. Is there a way to do this?