In userform, want to sum up to value from textbox7 to texbox 70.

[minmark]

<embed id="xunlei_com_thunder_helper_plugin_d462f475-c18e-46be-bd10-327458d045bd" type="application/thunder_download_plugin" height="0" width="0">Dear Gents,

I would like to add the value (sum) from textbox 7 to text box 70.
my plan is make a button to sum up these value...
activecell.value= TextBox7.value + TextBox8.value +........ +TextBox70.Value

Is there any way to express them through loop or sth?
I can't figure out the code...
I stuck in the setup of variable.....
please help..... thanks.
for i = 7 to 70


next i

 

[mikerickson]

Dim i As Long
Dim mySum as Double

For i = 7 to 70
    mySum = mySum + Val(Me.Controls("TextBox" & i).Text)
Next i

 

[minmark]

Dear Sir,

Thanks for your reply in time. It operate smoothly.~~
is Val() means value
Controls means those object in the Me?

Thanks.~~~

Dim i As Long
Dim mySum as Double

For i = 7 to 70
    mySum = mySum + Val(Me.Controls("TextBox" & i).Text)
Next i

<embed id="xunlei_com_thunder_helper_plugin_d462f475-c18e-46be-bd10-327458d045bd" type="application/thunder_download_plugin" height="0" width="0">