Hello,
New to the forum and have limited VBA / Macro experience.
What I would like to do is use Goal Seek or some variation of it solve for an amount required to achieve a certain IRR calculation (using XIRR) from a series of cash flows by being able to select the targeted IRR from a drop down menu.
I know that Goal Seek function generally solves as follows:
Set Cell =("B10") where my resultant Preferred Return (XIRR) is calculated, with the "to value" set at say 10%, by changing cell "F10". The value in F10 changes until the value in cell B10 = 10%. With Goal Seek, if I wanted to solve F10 for an IRR of say 12%, I would have to manually go in and modify the "to value" amount, then the calculation would be completed.
However, I would like to know if there is a way that would automatically change the "to value" in Goal Seek to match the selection from a drop down menu, say between 10% - 15% without having to manually change the "to value" in the Goal Seek function each time I make a change to the preferred return.
Again, you are dealing with a newbie here when it comes to VBA and Macros so be gentle.
Any help would be greatly appreciated.
Frank
New to the forum and have limited VBA / Macro experience.
What I would like to do is use Goal Seek or some variation of it solve for an amount required to achieve a certain IRR calculation (using XIRR) from a series of cash flows by being able to select the targeted IRR from a drop down menu.
I know that Goal Seek function generally solves as follows:
Set Cell =("B10") where my resultant Preferred Return (XIRR) is calculated, with the "to value" set at say 10%, by changing cell "F10". The value in F10 changes until the value in cell B10 = 10%. With Goal Seek, if I wanted to solve F10 for an IRR of say 12%, I would have to manually go in and modify the "to value" amount, then the calculation would be completed.
However, I would like to know if there is a way that would automatically change the "to value" in Goal Seek to match the selection from a drop down menu, say between 10% - 15% without having to manually change the "to value" in the Goal Seek function each time I make a change to the preferred return.
Again, you are dealing with a newbie here when it comes to VBA and Macros so be gentle.
Any help would be greatly appreciated.
Frank