奇怪,最近复制总出错。
Private Sub Command1_Click()
MsgBox sums(10)
End Sub
Function sums(ByVal n As Integer) As Long
sums = 0
Dim I As Long, J As Long, TEMP As Long
For I = 1 To n
TEMP = 1
For J = 1 To I
TEMP = TEMP * J
Next
sums = sums + TEMP
Next
End Function
Private Sub Command1_Click()
MsgBox sums(10)
End Sub
Function sums(ByVal n As Integer) As Long
Dim i As Long, j As Long, temp As Long
sums = 0
i = 1
For i = 1 To n
temp = 1
For j = 1 To i
temp = temp * j
Next
sums = sums + temp
Next
End Function
If Val(str) < 0 Then
MsgBox "错误!"
Else
For i = 1 To Val(str)
Sum = Sum + GetSumOfOrder(i)
Next
MsgBox Sum
End If
End Sub
Public Function GetSumOfOrder(ByVal Num As Integer) As Long
If Num > 1 Then
GetSumOfOrder = Num * GetSumOfOrder(Num - 1)
Else
GetSumOfOrder = 1
End If
End Function