Thread: How do cell events in the "Loan Amortization Schedule" template work?
View Single Post
 
Old 07-26-2020, 02:42 PM
revans611 revans611 is offline Windows Vista Office 2007
Novice
  
Join Date: May 2009
Location: Houston, TX
Posts: 9
revans611 is on a distinguished road
Question How do cell events in the "Loan Amortization Schedule" template work?
I am trying to learn how Microsoft's "Loan Amortization Template" works in my Office 365 version of Excel.



If the user enters a number in the cell named LoanPeriod, or in the cell named PaymentsPerYear, the spreadsheet automatically recalculates the number of payment lines to display. How does that happen? I can find no VBA behind code for the spreadsheet.
Reply With Quote