Hi

I am developing a leasing agreement and amortization schedule for a client and i have hit a development snag.

I need to create a user input form in which the workbook user can enter the number of years of the lease/loan and then manually input the annual value of ballooning payments or interest.

So, the sheet has a selection field for years (term) of 1-10 years. With that selection, I want to have the user be able to pull up an input form in which the number of input boxes on that form is based on the number of years selected. If possible, i would like to have the default value of that input be equal to the field value of the table populated by the form (in case of any changes needing to be made to the inputs.)

I hope this is making sense.

1. Input box where the number of fields displayed is dynamic based on the number of years selected on the workbook input screen (field name: loan_term)
2. Input box fields default value are equal to 0% OR the value of the table field (table name: tbl_annual_interest_rates)
3. Fields are populated by the form via normal vba code (i have that down)

Thanks for any help.