User-defined Function With Varible Number of Inputs



I am trying to create a VBA function that will take a variable number
of inputs. Is there a way to declare a variable number of inputs for
a function? I have found that if I don't use the total number of
inputs declared, I will get #Value. My thought is that a loop could
be created to count the number of inputs used in the statement in
Excel =myfunction(input1, input2, input3.....).

This is probably a simple problem but I haven't been able to find the
solution yet.




A ParamArray does that.

Sub fsdadfs()
MsgBox UDFTest("a", "b", "c")
End Sub

Function UDFTest(ParamArray args() As Variant) As String
Dim s As String
Dim i As Integer
For i = LBound(args) To UBound(args)
s = s & args(i) & vbLf
UDFTest = s
End Function

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question