"type mismatch" in the label caption

[KhallP]

I'm trying to perform a calculation in vba but when the program does it the error "Type mismatch" appears because the result is 0, can someone help me?

 

[RoryA]

Your variables contain text, which is what causes the error. "35" + "-15" actually evaluates to "35-15" (because both arguments are text, the + operates the same way as & would) not to 20.

 

[KhallP]

Your variables contain text, which is what causes the error. "35" + "-15" actually evaluates to "35-15" (because both arguments are text, the + operates the same way as & would) not to 20.

friend, but the error only occurs when the account value is 0, in the other forms I have the formulas exactly the same and as the result is not 0 the formula results and assumes the correct value

 

[KhallP]

Your variables contain text, which is what causes the error. "35" + "-15" actually evaluates to "35-15" (because both arguments are text, the + operates the same way as & would) not to 20.

and my variable is set to "variant"

 

[RoryA]

35-15 is not 0, so I'm not sure where you are getting that idea from.

 

[RoryA]

and my variable is set to "variant"

And your variants contain text.

 

[KhallP]

And your variants contain text.

but if i put the value of the variables as integer when the value is empty it as the type is "integer" it will always assume the value as "0" right? Is that in my program the variable can be empty, how can I solve the problem like that?

 

[RoryA]

In the pictures you posted, the calculation is not 0.

 

[KhallP]

In the pictures you posted, the calculation is not 0.

review the answer please i edited

 

[RoryA]

If an empty textbox is not a valid input, you need to handle that in whatever manner is appropriate - eg treat it as 0, or flag it as an error to the user.