By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,375 Members | 3,030 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,375 IT Pros & Developers. It's quick & easy.

I can not add more than 92

P: 14
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
Jul 17 '07 #1
Share this Question
Share on Google+
3 Replies


JKing
Expert 100+
P: 1,206
Use the line continuation character _ to continue a line of code on a new line

Example:
Expand|Select|Wrap|Line Numbers
  1. Dim intBigNumber as Integer
  2.  
  3. intBigNumber = 1 + 2 + 3 + 4 + 5 _
  4.                  + 6 + 7 + 8 + 9 + 10 _
  5.                  + 11 + 12 + 13 + 14 + 15
  6.  
Jul 17 '07 #2

P: 14
Hi JKing

Thank you so much, you are right.
Jul 17 '07 #3

JKing
Expert 100+
P: 1,206
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.
Jul 17 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.