automate solver

  • Thread starter Thread starter paddy
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: Help creating a macro that will run Solver? 3
Solver or not Solver 4
Solver not found 1
Solver Error - an unexpected internal error has occurred 1
Solver won't open 1
Solver 3
How do you use excel solver after installing the add-in? 3
Solver with If then else? 3

Back
Top