Finding VB Programming Accumulation Problems

Is it to add a cycle, but to know the number of cycles.

Do you mean that.

Just start text1=2 text=3

Click once text3=5

The second time - text1=x text2=x click again - text3=x+x+5

If that's the case.

The txt genus of text3 is set to 0

Then in the "click" event in your additive command.

private sub cmdleijia_click()end sub

That's it, if you still have to think about more points, I can't enter letters, I won't write anything, just tell you the method of accumulation, in fact, it is the sum of text1 and text2, plus the original value of text3, and the accumulation is realized.

Due to the small amount of data and the uncomplicated logical relationship, it can be achieved with formulas, without the need for VBA to enter formulas in B2 cells.

b1+a1 and then drop down the formula.

Enter the formula inside cell C2.

if((c1+a2)>1500,16,(c1+a2)) and then pull down the roller formula.

Enter the formula inside cell d2.

if((d1+a2)>4500,16,(d1+a2)) and then drop down the formula.

I hope it will be useful to you if you seem.,If there is no scum spine to understand, please hi.

public function b(byval n as integer)

if n = 1 then

b = 1else

b = b(n - 1) *n

end if

end function

private sub command1_click()dim n as integer

n == b(n)

end sub

You can enter 10 there, where n<=170. That is, it can only be counted to 170!, overflowing in the big one.

for j=2 to 88

sum = sum + j

next j

msgbox "2 The sum of the numbers between 88 is equal to" & sum