b'Loop Until pA 0 Range("B4") = pADo TEM = InputBox("Ingrese Tasa efecvtiva mensual (TEM)", "Ingreso de datos") If TEM 0 Then MsgBox "Dato mal ingresado", vbCritical, "Ventana de Error" End If Loop Until TEM 0 Range("B5") = TEMN = 0 Do While (SI 1000) N = N + 1 I = SI * TEM A = Round(SI * pA, 2) R = I + A SF = SI - A Cells(N + 7, 1) = N Cells(N + 7, 2) = SI Cells(N + 7, 3) = I Cells(N + 7, 5) = A Cells(N + 7, 4) = R Cells(N + 7, 6) = SF SI = SF Loop N = N + 1 I = SI * TEM A = SI R = I + A SF = SI - A Cells(N + 7, 1) = N Cells(N + 7, 2) = SI Autor: Jos M. Martn Senmache S.Pgina 453'