Thank you for your response Calus.
I don't have any problems with the Solver code itself, just the Macro code to initiate the Solver. Instead of asking the user to initiate the Solver, manually, I'd like to be able to set up the Macro so that they click the textbox "Run calculator" and the Solver will automatically run.

Any tips?

On Saturday, March 22, 2014 12:15:45 AM UTC-7, Claus Busch wrote:
Hi,



Am Fri, 21 Mar 2014 18:48:53 -0700 (PDT) schrieb :



I've set up a Solver in an excel sheet, and I'm trying to create a macro that will initiate the Solver when the user clicks a textbox in the Excel sheet.



I recorded the macro, and it runs splendidly on Excel 2010. However, when I try to run it on Excel 2007, I receive the error message: "Solver: An unexpected internal error occurred, or available memory was exhausted."



for solver you have a range with values and a range with a formula. You

set a value for the range with the formula and set the range to change

to the range with values. E.g. this could look like:



'H13 is the cell with the formula

SolverOk SetCell:="$H$13", _

MaxMinVal:=3, _

ValueOf:="0", _

ByChange:="$G$13:$G$17" 'G13:G17 is the range

SolverSolve 'with the values





Regards

Claus B.

--

Vista Ultimate SP2 / Windows7 SP1

Office 2007 Ultimate SP3 / 2010 Prodessional