UserForm TextBox's Calculation

[z-eighty2]

Hi,

In my userform I have 4 " TEXT BOX's" for calculations.

TextBox1 = TextBoxTotalFees (I have freez this text box)
TextBox2= TextBoxDiscount
TextBox3= TextBoxAmountReceived
TextBox4 = TextBoxAmountDue (I have freez this text box)



TextBox1 shows me automatically fess in this box when I select a number of checkboxes..It is working fine.( I have freez this text box)

Now I want to show me Total Amount Due in (TextBox4) after subtracting values like this...

TextBox4 = TextBox1 - TextBox2(If No discount is given it should show automatically " 0 " or leave blank in this box) - TextBox3

It should not give any error (mismatch 13) if by mistake the user enter character in the TextBox2 or TextBox3 but it should display message to enter a numerical number.

Here is the code which I tried so far except TextBox2(discount)

Please Login or Register  to view this content.

I will very thankful If anyone could help me please.

[Norie]

Perhaps this which can be repeated for TextBoxAmountReceived

Please Login or Register  to view this content.