+ Reply to Thread
Results 1 to 4 of 4

Goal Seek VBA - Interest Reserve

  1. #1
    Registered User
    Join Date
    10-18-2018
    Location
    Scottsdale, AZ
    MS-Off Ver
    Office365
    Posts
    2

    Goal Seek VBA - Interest Reserve

    Hi everyone,
    I have a model that includes a construction loan that requires an interest reserve be included in the overall loan budget. The model calculates the total projected interest based on this budget (cell A2).
    Then, and using this value (A2) as reference, I manually add the interest reserve amount to the budget (via cell A1), which then changes the value of cell (A2). I then play (manually) with the Value of (A1) until it is equal to the value in (A2). I'd like to create a macro that will automatically optimize the interest reserve in (A1) so that it equals that in (A2(. The traditional Goal Seek function won't work in this instance because if requires that you have a fixed target to solve to. I suspect that a DO UNTIL loop that sets the value of A1 to $1, checks to see if A1=A2, and if not, adds $1 to A1 and checks again, etc. is whats required but i have been unable to find the code.

    Any help would be appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Goal Seek VBA - Interest Reserve

    Nice model. Too bad you didn't share it

  3. #3
    Valued Forum Contributor Hydraulics's Avatar
    Join Date
    07-15-2018
    Location
    Udine - Italy
    MS-Off Ver
    Office 365
    Posts
    370

    Re: Goal Seek VBA - Interest Reserve

    Quote Originally Posted by greggwolin View Post
    The traditional Goal Seek function won't work in this instance because if requires that you have a fixed target to solve to.
    Without seeing your worksheet this might be a shot in the dark, anyhow one option is setting Goal Seek to zero on the cell containing the difference A2-A1 (or A1-A2) letting it change A1.

    HTH,

    Francesco
    Aim high or don't even try.
    ---------------------------------
    If your question has been answered, don't forget to mark the thread as SOLVED.
    If you find an answer helpful, click on the star icon at the bottom of the post.

  4. #4
    Registered User
    Join Date
    10-18-2018
    Location
    Scottsdale, AZ
    MS-Off Ver
    Office365
    Posts
    2

    Re: Goal Seek VBA - Interest Reserve

    Great shot in the dark! Occams Razor strikes again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. What is use of Goal Seek
    By Terressa in forum Excel General
    Replies: 1
    Last Post: 07-07-2015, 07:10 AM
  2. [SOLVED] Seeking Goal without using Goal Seek
    By Doc Science in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-07-2015, 02:24 PM
  3. Replies: 3
    Last Post: 07-27-2012, 01:44 PM
  4. Goal Seek VBA with relative 'Goal' parameter
    By alirulez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2012, 07:19 PM
  5. Goal Seek Formula But Not Using Goal Seek
    By cady923 in forum Excel General
    Replies: 1
    Last Post: 08-05-2011, 03:53 PM
  6. VBA Goal Seek
    By craigafrica in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-28-2008, 11:32 AM
  7. goal seek
    By kc27315 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-17-2008, 09:49 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1