Currently people seem to face a lot of difficulties to secure a loan or have problem to pay back a loan. Still, we need to borrow money every now and then to acquire an asset or to pay for education fees. So, naturally we need to find out how long we can settle a loan for a certain amount of monthly payment at a certain interest rate. It is not easy to calculate such figure, fortunately VB comes to the rescue. There is a builtin function in VB to calculate the pay back period, it is known as Nper and the syntax is
Nper(Rate,Pmt,Pv,Fv,Due) Rate=Interest Rate Pmt=Amount of Periodic Payment PV=Loan taken FV=Future Value (set to 0 if load is settled) Due=set to 1 if payment at the beginning of the period set to 0 if payment at the end of the period 

The CodePrivate Sub Command1_Click() 
The Interface 
Copyright ® 2008 Dr.Liew Voon Kiong . All rights reserved Contact: admin@vbtutor.net