Run-time error

[asyamonique]

TextBox11 = TextBox9.Value - TextBox10.Value

Hello,
If there is no data at one of the textboxes I'm having an error as Run-time error '13': Type mismatch
What is the solution to fix that problem?

 

[asyamonique]

On Error Resume Next

 

[footoo]

TextBox11 = Val(TextBox9) - Val(TextBox10)

 

[asyamonique]

Thank you,
If I add together below code it does not showing the deciminal values correctly.
What is the solution for it?

TextBox11.Text = Format(TextBox11.Text, "###,##0.00")

 

[footoo]

Thank you,
If I add together below code it does not showing the deciminal values correctly.
What is the solution for it?

TextBox11.Text = Format(TextBox11.Text, "###,##0.00")

It works for me.
In what way is it not working?
Do you mean that if the text box is blank, you want it to show 0.00 ? If so :

TextBox11.Text = Format(Val(TextBox11.Text), "###,##0.00")

Or perhaps you are looking for :

TextBox11 = Format(Val(TextBox9) - Val(TextBox10), "###,##0.00")