Loan amortization schedule in VBA

[amd_502]

Hi,

I am new to VBA in excel and would like to know the steps how to prepare a loan amortization schedule for new loans in a simple example.

Many Thanks,

 

[vletm]

amd_502
You asked steps:
Have a clear idea - how to do it manually?
Have a clear idea - what are needed inputs?
Have a clear idea - what is needed output?
Have a clear idea - what is needed layout?
Open an Excel code page
Write eg Sub New_Loan_Amortization() -text
Make few empty lines
Write End Sub-text
Write You clear idea between those code-lines