Sum of the numbers of one textbox
 

How can I get the sum of the numbers of only one textbox?
For example text1.text= 1367
How to get the sum of this 4 digit number?

I appreciate your assistance in advance.
Lida

Dear Lida,

Try this:

text1.text = 1367
text2.text = sum(text1.text)

if you want only 4 digit will type in text box then adjust the properties of text box. max length = 4

To all...
 

I'm not sure if the solution is so easy as you write... VB(at least my 6 one) does not have the sum function... its necessary to write it at first. It could looks like this:

Public Function SUM(sNumber as String) As Integer

dim iX as integer, iCount as integer

     for iX = 1 to len(sNumber)

          iCount = iCount + CInt(Mid(sNumber, iX, 1))

     Next iX

     SUM = iCount

End Function

:)

Unfortunately this also doesn't work....I've already tried it.. :(:(

This one doesn't work either.... :(

Lida_Pink,

Lets make sure of our definitions first... The sum of numbers is, those numbers being added together, while the product of numbers is, those numbers being multiplied together. So if you want the sum of numbers in a string then celt.max's code does work...

Option Explicit



Private Sub Form_Load()

Dim Result As Integer

Result = SUM("1234")

MsgBox Result

End Sub



Public Function SUM(sNumber As String) As Integer

Dim iX As Integer, iCount As Integer

     For iX = 1 To Len(sNumber)

          iCount = iCount + CInt(Mid(sNumber, iX, 1))

     Next iX

     SUM = iCount

End Function

However, if you are wanting the product of the numbers, then yes a different solution is needed. So, are you wanting the product of these numbers?



Good Luck

Try the following to get the sum of an integer -

Private Sub Command1_Click()

On Error GoTo Errorhandler

x = InputBox("Please Enter an Integer.", , Text1.Text)

If x <> "" Then

    List1.AddItem Str(x)

        Do While x <> 1

            If x Mod 2 = 0 Then

                x = x / 2

            Else

                x = (x * 3) + 1

            End If

            List1.AddItem Str(x)

        Loop

'Number of steps used

Label1 = List1.ListCount - 1

End If

Errorhandler:

    Exit Sub

End Sub



'Even numbers are divided by 2

'Odd numbers are multiplied by 3 and are then increased by 1

'The problem ends by reaching the number 1

I need the sum of the numbers. And thank you very much. Your answer is correct.
Cheers,
Lids