How do cell events in the "Loan Amortization Schedule" template work?

[revans611]

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.

[ORoos]

Hi revans611,
Welcome to the forum.
Please see the yellow banner at the top on how to attach a sample file.
Without being able to see what you are working with, it is difficult to help.