Quote Originally Posted by MrShorty View Post
I am not real skilled at calling Goal Seek from VBA. My thought on approaching this problem.

Rather than requiring VBA/Excel/myself to look back at "settings" to get the target return rate, I would tend to link this up on "model", then add another helper cell that will calculate the calculated IRR (G12 or G13)-target. Then my goal seek will always be "seeking" a target value of 0.

See attachment. I have added cells to model to 1) choose equity or capital, and 2) calculate the difference between target IRR and calculated IRR. 3) Goal seek code is unchanged,except for references to target cell and target value. I have also added a link on "result" to the value determined from the Goal seek. I went for a "minimal use of VBA" approach, which means the only VBA statement used is the goalseek statement.
Thank you so much, really appreciate it.

Nice to know my goalseek part of my code was correct. Might become half decent at this some day