Using Goal Seek on a userform with variables

[bugatti79]

Folks,

I have found the following code in help file regarding the goal seek function

Worksheets("Sheet1").Range("Polynomial").GoalSeek _
<code>    Goal:=15, _    ChangingCell:=Worksheets("Sheet1").Range("X")

Is it possible to modify this such that I can use variables? For example, the variables are 'left term', 'right term' and 'sigma max'

I want to set the value of the following equation 'left term - right term' to 0 by changing variable 'sigma max'
Everything is done on the userform and not in the spreadsheet.

(Note: In spreadsheet format, the above query is equivalent to setting a cell which has a formula to 0 by changing the value in another cell, fairly simple)

Any ideas?

Thanks


</code>

 

[Andrew Poulsom]

The GoalSeek method applies to a Range and expects a Range as its second argument. So the answer is no, unless your variables are Range objects.

 

[bugatti79]

Thank you. Got it working with range objects.

 

[bugatti79]

Thank you. Got it working with range objects.