Just to add:

goalseek uses the setting in the Iterations section of
tools=Options=Calculation.


--
Regards,
Tom Ogilvy


"Monique" wrote in message
...
OK.

Right now, an input box appears. The user types in a number.
The number the user inputs is the goal that I want to affect the Price.

if i used goalseek, it would look like:

range("W42").goalseek goal:=newCV, changingcell:=range(price)

i don't have a set number of iterations. i just want it to reach the goal
as
close as possible and update the cell at the end.

Can you please help me?



"Tom Ogilvy" wrote:

Just keep substituting values (incrementing your start value) until your
function achieves the goal (within a tolerance), or you reach some limit
in
the number of increments. I don't think goalseek is any smarter than
that.

--
Regards,
Tom Ogilvy

"Monique" wrote in message
...
I need to write a function that will mimic the function of goalseek.

I cannot use .goalseek in my code for other platforms cannot support.

If anyone could help me... it would be appreciated.