如果要在数组里返回值的话,用 function a(byRef b() as Integer) as long
Dim B(X) As Integer Function A(B(X) As Integer) As Long ... End Function 说明:X为自然数。
Private Function SumAll(Val() As Integer) As Long Dim i As Long Dim ub As Long ub = UBound(Val) For i = LBound(Val) To ub SumAll = SumAll + Val(i) Next End FunctionPrivate Sub Command1_Click() Dim m(2) As Integer Dim n(2 To 3) As Integer For i = LBound(m) To UBound(m) m(i) = i Next For i = LBound(n) To UBound(n) n(i) = i Next 'MsgBox SumAll(m) & vbCrLf & SumAll(n) '这样写也可 MsgBox SumAll(m()) & vbCrLf & SumAll(n()) End Sub
function a(byRef b() as Integer) as long
Function A(B(X) As Integer) As Long
...
End Function
说明:X为自然数。
Private Function SumAll(Val() As Integer) As Long
Dim i As Long
Dim ub As Long
ub = UBound(Val)
For i = LBound(Val) To ub
SumAll = SumAll + Val(i)
Next
End FunctionPrivate Sub Command1_Click()
Dim m(2) As Integer
Dim n(2 To 3) As Integer
For i = LBound(m) To UBound(m)
m(i) = i
Next
For i = LBound(n) To UBound(n)
n(i) = i
Next
'MsgBox SumAll(m) & vbCrLf & SumAll(n) '这样写也可
MsgBox SumAll(m()) & vbCrLf & SumAll(n())
End Sub