I can not add more than 92

[SAMI2]

I can not add more than 92, when I add + Val(A93), it come in new line with red color

Private Sub TextTestResult_ Enter()
TextTestResult = Val(A1) + Val(A2) + Val(A3) + Val(A4) + Val(A5) + Val(A6) + Val(A7) + Val(A8) + Val(A9) + Val(A10) + Val(A11) + Val(A12) + Val(A13) + Val(A14) + Val(A15) + Val(A16) + Val(A17) + Val(A18) + Val(A19) + Val(A20) + Val(A21) + Val(A22) + Val(A23) + Val(A24) + Val(A25) + Val(A26) + Val(A27) + Val(A28) + Val(A29) + Val(A30) + Val(A31) + Val(A32) + Val(A33) + Val(A34) + Val(A35) + Val(A36) + Val(A37) + Val(A38) + Val(A39) + Val(A40) + Val(A41) + Val(A42) + Val(A43) + Val(A44) + Val(A45) + Val(A46) + Val(A47) + Val(A48) + Val(A49) + Val(A50) + Val(A51) + Val(A52) + Val(A53) + Val(A54) + Val(A55) + Val(A56) + Val(A57) + Val(A58) + Val(A59) + Val(A60) + Val(A61) + Val(A62) + Val(A63) + Val(A64) + Val(A65) + Val(A66) + Val(A67) + Val(A68) + Val(A69) + Val(A70) + Val(A71) + Val(A72) + Val(A73) + Val(A74) + Val(A75) + Val(A76) + Val(A77) + Val(A78) + Val(A79) + Val(A80) + Val(A81) + Val(A82) + Val(A83) + Val(A84) + Val(A85) + Val(A86) + Val(A87) + Val(A88) + Val(A89) + Val(A90) + Val(A91) + Val(A92)
+ Val(A93)

End Sub


Thanks

[JKing]

Use the line continuation character _ to continue a line of code on a new line

Example:
[code=vb]
Dim intBigNumber as Integer

intBigNumber = 1 + 2 + 3 + 4 + 5 _
+ 6 + 7 + 8 + 9 + 10 _
+ 11 + 12 + 13 + 14 + 15
[/code]

[SAMI2]

Hi JKing

Thank you so much, you are right.

[JKing]

You're welcome. I suggest using the line continuation character instead of making huge lines anyways. It's easier to read and scrolling can be a pain.