Goal Seek with constraint?

[Tkeller]

I think I know the answer to this question. I have a goal seek problem, but in certain cases, the goal seeker goes nuts and starts putting in negative numbers as the input - I need to constrain the input cell to a positive number. So is I am setting cell "output" to Zero by chaning cell "input", I need to be sure that "input" is positive. Is there a way to do this in VBA?

If not, I will have to use SOLVER in VBA. If I use solver, as I know it is an addin, is there a way to be sure that every user will be able to use and what would the code be for something as simple as set "output" to by changin "input", subject to "input" >0.

thanks,
tom

 

[shg]

GoalSeek doesn't support constraints.

Solver is part of the standard Excel distribution, but installation is (I recollect) optional.

The model changed in 2007 to expose more stuff, but 2003 code will work in later versions. There are many examples of automating Solver on the board.

 

[Tkeller]

Thanks. I did not think Goal Seek could be configured with even a simple constraint, but thought I would ask to make my life simpler

I'll find an example using solver...