Rune-time 6 overflow

[kylec23]

I am trying to run the follow code. Not sure why I'm getting an overflow because the equations that are being performed are super simple and not returning large values.

TextBox5.Value = Val(TextBox1.Value) / Val(TextBox2.Value)

Any help is appreciated

 

[offthelip]

if is almost undoubtedly because Val(textbox2.value is zero at some point which will give you an overflow, probably when the textbox first opens :so change the code to this:

If Val(TextBox2.Value) <> 0 Then
TextBox5.Value = Val(TextBox1.Value) / Val(TextBox2.Value)
Else
TextBox5.Value =0
End If

 

[kylec23]

if is almost undoubtedly because Val(textbox2.value is zero at some point which will give you an overflow, probably when the textbox first opens :so change the code to this:

If Val(TextBox2.Value) <> 0 Then
TextBox5.Value = Val(TextBox1.Value) / Val(TextBox2.Value)
Else
TextBox5.Value =0
End If

This worked, so thank you very much for that.
Would you be able to explain to me how Val(TextBox2.Value) would be returned zero when in fact that was a number that was input?

 

[offthelip]

I woudl assume it would be zero before you make the input, thus that is probably when it crashes

 

[Fluff]

If textbox2 was 0 you would get a division by 0 error, not an overflow error.
What were the 2 numbers when you got the error?

 

[kylec23]

I woudl assume it would be zero before you make the input, thus that is probably when it crashes

It was, but that code was inside of TextBox2_Change()

 

[kylec23]

If textbox2 was 0 you would get a division by 0 error, not an overflow error.
What were the 2 numbers when you got the error?

I was trying super simple things to test. 70/10, 60/6. Nothing crazy.

 

[Fluff]

I cannot replicate the error you are getting with those numbers, or any others. So not sure why that is happening.

 

[RoryA]

Do you have any code behind textbox5?

 

[kylec23]

Do you have any code behind textbox5?

I do not. Was strictly for holding value (made invisible to user) and spitting out into database sheet.