Automate Goal Seek

**marcghannoum@gm** · 10-04-2008, 04:17 PM

Hi guys,

I am not an excel expert but I do play around it a little. Here is my worksheet. Basically, I would like that everytime I change a variable (in yellow), the changing cell (in blue) changes so that the target cell (in pink) stays at 2. I don't want to restart goal seek everytime, i want it to change it automatically.

I need this before monday! Please also mention what and how you achieved this.

thx\

**shg** · 10-04-2008, 05:46 PM

Name cell F5 Time

Name cell H5 RealKTv

Open the VBE, add a reference to Solver, and put this in the Sheet module:

Please Login or Register  to view this content.

The purpose of this forum is to help people learn Excel. Sending workbooks around by email defeats that; please don't solicit to do so again, and please read the Forum Rules about thread titles (and in general) before starting your next thread.

**marcghannoum@gm** · 10-04-2008, 06:59 PM

Hi,

Thx a million for the help! Unfortunately, I've never used the VBE functions. Can you give me the steps one by one (sorry about that, guess i'm even worse than i expected).

So, in excel:
1) Go to Developper tab
2) click Visual Basic
3) on the open window on top left go on sheet 1

then?

If you could do it for me, i would sure be grateful, sorry about that!

Marc

**marcghannoum@gm** · 10-04-2008, 07:12 PM

you can resend me the worksheet through here, no need for email.

**marcghannoum@gm** · 10-04-2008, 09:57 PM

ok i tried my best, i think i did everything you mentionned. Doesn't seem to work. Sorry

**ratcat** · 10-05-2008, 12:15 AM

G'day Marc,

I noticed that your using xl 2007 if this is correct try the following options.

There two options you have to do

Option One

In the Visual Basic Editor, with a module active, click References on the Tools menu, and then select the Solver.xlam check box under Available References. If Solver.xlam does not appear under Available References, click Browse and open Solver.xlam in the \office12\library\Solver subfolder.

If that did not work, try

Option 2

Go to the Office Button > Excel Options > Add-Ins > click on 'Solver Add-in' >

Click 'Go' (not 'Ok') > Tick the box 'Solver Add-in' > click on 'OK'.

Wait for the program to load the Add-In.

Go back to the Visual Basic Editor > Tools > References > tick the box 'SOLVER' > click 'OK'

Then

Originally Posted by martindwilson

PFM

Cheers

**sarahbolty** · 01-26-2009, 02:47 PM

Hello,
I am trying to use the VBA code you suggested above to automate goal seek. how do i call the procedure in the sheet so that excel remembers to run the goal seek every time i change the underlying value.
Thanks