Rewrite the subroutine in the previous exercise so that the user interface is as demonstrated in the following screen shots. Some of the functions needed to write the subroutine were not covered in the text. We used the following functions:

? Val ?A function used to convert a string of digits to a number.

? Left ?A function used to return the left part of a string.

? Right ?A function used to return the right part of a string.

? FormatPercent ?A function used to format a number.

? FormatCurrency ?A function used to format a number.

More information about these functions is available from the VBA Help file. We recommend you use it.

Transcribed Image Text:

New PV Calc New PV Calc Cash flow entéred:100.25 Enter the interest rate: Enter the cash flow: OK OK Cancel Cancel 100.25 12.454 Microsoft Excel Book1.xls Ele Edit View Insert Format Tools Arial 12 B I A New PV Calc New PV Calc X Cash flow entered:100.25 Interest rate enterd:12.4500% Enter the number of periods: OK 100.250 PV is:E630.058 Cancel 12.450% 3 OK D 13 4 13 630.0580 <-- =-PV(A3,A4,A2) ....