Solver Value VB Question

J

Jenn

Hi. Two quick questions:
1. I would love to be able to type a value in a specific cell and have it
feed the "Value Of " box in the solver tool. (Under the menu Tools/Solver).
Is there any code that can help me do this instead of having to always select
the solver and enter a specific value in the "Value of" text box?

2. Can I put a button on my worksheet that will activate the solver instead
of having to go through Tools/Solver and select the solve button from there?

Thanks in advance!!!
 
Top