Text box math

[CarlosMitc]

I left this thread in the general section also but im not getting much help there.

Here is the code im having a problem with

Text23.text = Val(text10.text) * 50
Text12.text = Val(text1.text) / Val(Text23.text)

On the second line I recieve a overflow error could this be happening because text1.text = 0
I have tried the clng instead of val also.

Thanks to anyone that can help

[Sam Finch]

You should only get an overflow error if the value of text10 is really small, or 0. (actually if it's 0 you'll get a division by 0 error. try it with numbers between 1 and 10. you shouldn't have any problems.

[CarlosMitc]

Actually the number in text10 is from 1-480
and Text1 is 1-24000 I have done a work around

IF Val(Text10.text) > 0 Then Text23.text Val(text10.text) * 50
IF Val(Text1.text) > 0 Then Text12.text = Val(text1.text) / Val


This seems to work but there may still be a problem Im
not getting an overflow error now

[CarlosMitc]

Actually the number in text10 is from 1-480
and Text1 is 1-24000 I have done a work around

IF Val(Text10.text) > 0 Then Text23.text Val(text10.text) * 50
IF Val(Text1.text) > 0 Then Text12.text = Val(text1.text) / Val


This seems to work but there may still be a problem Im
not getting an overflow error now