Hi
I am creating a user form on excel so that the user is prompted to input values and on clicking 'OK', the program returns a loan schedule of the loan amount and the scheduled payments etc. I have created the user-form and I have managed to connect the each text box (where the user inputs values) to each relevant cell in the workbook by using the formula
[code]
Range("D5").Formula = UserForm1.TB1.Value
[/code
And changing the cell and textbox name in each case. Now what I wish to do is set conditions on each of the textbox in order to limit what the user is able to input. On entering something incorrect, the user should be prompted by a message box. For example, for one of the textboxes, I want the value entered by the user to be rounded down to the nearest integer value. The value also should be no smaller 5000. How would I go about doing this?

Any help would be greatly appreciated!
Thanks in advance!