Automated Goal Seek VBA Help

[dmasvidal]

Hello,

I have limited/no VBA experience but significant excel experience (using 2007 now). I'm trying to create an automated Goal Seek function that will automatically (upon changing of "to value", which I also need the function to seek a particular cell and not a set value) run a Goal Seek and output to the "set cell" value. I've tried a dozen VBA scripts basically copy pasted from various other forums, but no such luck.

Can anyone help with a mini-tutorial?

Thanks

 

[pedie]

Something like this?

Worksheets("Sheet1").Range("Polynomial").[B]GoalSeek[/B] _
    Goal:=15, _
    ChangingCell:=Worksheets("Sheet1").Range("X")

http://www.mrexcel.com/forum/showthread.php?t=64045
try the above link