at the moment the number gets put at the end, but the list box starts negative and then gets larger and the values that will be added are within the range already there, My guess would be some sort of sort function?
Full form of PMT function PMT formulas for weekly, monthly, quarterly and semi-annual payments What is the PMT function in Excel? The Excel PMT function is a financial function that calculates the payment for a loan based on a constant interest rate, the number of periods and the loan amoun...