Hi,

Thanks for your help in the last post. There is one problem I am having
though. I need to input numbers into an input box in the userform, and I
would like the numbers formatted. I have the input box linked to a cell in
the workspace. But using the code

TextBoxPayments.value = format(Sheets("Input").Range("D8").Value, "$#,##0")
or
TextBoxPayments.value = Sheets("Input").Range("D8").text

Does not allow me to change the value in the input box, it sets the input
box to the value in D8. Is there any way around this so I can input values
that are formatted?

Thanks for your help