automate solver

P

paddy

I have a spreadsheet where I use the Solver add-in. It
works really well.

To make it better I want to "automate" Solver, so that
when a cell value is changed by a user - Solver is
activated automatically and the solver result is
calculated and displayed.

I want to avoid the user needing to click on Solver in
the tools menu bar and the dialogue boxes associated.

I have tried recording a macro to complete this, but seem
to have issues accessing SOLVER.XLA and procedures
relating to it???

Any help welcome.

Truly thankful, Paddy
 
T

Tushar Mehta

Check XL VBA help for any solver function. Near the top will be
information about creating a reference to the Solver library.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Top