"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?

 

[KhallP]

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.

I really don't know what's going on, the account gave an amount that I don't know how it was calculated

 

[RoryA]

I don't know either. You have the workbook, so you'll have to step through the code to see what is happening

 

[KhallP]

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.

I tried to convert the variables, do you think this will work?

   Y2_Axis_Orig_D = CInt(Y2_Axis_Orig_D)
        Z_550_Orig_D = CInt(Z_550_Orig_D)

 

[RoryA]

As long as the variable contains something that can be converted to an integer, yes.

 

[KhallP]

As long as the variable contains something that can be converted to an integer, yes.

how can i do the reverse? in this case pass an integer variable to a "variant" variable

 

[RoryA]

Just assign it to the variable. A Variant can contain anything.

 

[KhallP]

Let me explain, I have a module that contains public variables and on a specific Form I assign a value to that variable that is specified as integer in the module, but later on in another form I need to pass these variables to "variant" how can I do this ?

Just assign it to the variable. A Variant can contain anything.

 

[RoryA]

As I said - just assign it:

myVariant = myInteger

for example.