How to accept any number of arguments in a function

Home » Coding Basics » How to accept any number of arguments in a function

How to accept any number of arguments in a function

Posted on January 4, 2009

'Coding Basics - How to accept any number of arguments in a function
You can implement a routine that accepts any number of arguments using the ParamArray keyword
 
Function Sum(ParamArray args() As Variant) As Double
    Dim I As Integer
    ' All ParamArrays are zero-based.
    For I = 0 To UBound(args)
        Sum = Sum + args(I)
    Next
End Function