InitLoan = InputBox("Input Loan amount:")Ĭells(4, 2).Value = Format(intRateYrs, "#.#") & " %"Ĭells(4, 3).Value = Format(intRateMths, "Percent")Ĭells(6, 2).Value = Format(initLoan, "Currency") LoanLifeYrs = InputBox("Input Loan life (Years):") IntRateYrs = InputBox("Input Interest rate (Annual):") Sub one()ĭim intRate, loanLife, initLoan, payment As Doubleĭim yearBegBal, intComp, prinComp, yearEndBal, intTot, prinTot, fvloan As Currency I am requesting changing the script below to take the values from 3 columns. I already have a working VBA script(given below) to calculate the amortization schedule but I want it to take the inputs from the 3 columns, calculate it for 7328 rows(instead of manually putting it in) and append the values below each other. I have three columns Sanctioned Amount, Tenure and Rate of Interest for 7328 rows. I am new to Excel VBA and looking for help in editing a macro.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |