Is it possible to perform a goal seek in excel when the value is caluculated by a macro

[spurs]

I use goal seek frequently and i noticed that if a function is used in a cell the goal seek works but if calculated by a subroutine it cannot

Is there a way to calculate via goal seek a value calculated through a subroutine?

 

[rakesh seebaruth]

Yes, there is a way to use Goal Seek to calculate a value calculated through a subroutine. You can create a VBA subroutine to run Goal Seek anytime there is a change on a worksheet. Alternatively, you can also enable iterative calculations in Excel Options. This will allow Excel to handle circular references, or cell formulas that refer to their own result as an input to the cell formula. However, you need to set the maximum number of iterations and the maximum change (accuracy) appropriately to avoid a very long iterative loop.

 

[spurs]

Yes, there is a way to use Goal Seek to calculate a value calculated through a subroutine. You can create a VBA subroutine to run Goal Seek anytime there is a change on a worksheet. Alternatively, you can also enable iterative calculations in Excel Options. This will allow Excel to handle circular references, or cell formulas that refer to their own result as an input to the cell formula. However, you need to set the maximum number of iterations and the maximum change (accuracy) appropriately to avoid a very long iterative loop.

Are you saying that the vba code I need to create would goal seak inside my code as opposed to use the built in excel method?