Returning multiple values from a function

[dlpastel]

A basic question but I have never done it.

I need to return multiple values from a function. What is the correct syntax?

myvalue = myfunction()


function myfunction() as string
myfunction = "my result"
end function

I know this makes myvalue be the value of myfunction but what if I want to return 4 or more values?

Thanks,
Dan

 

[MichaelRed]

In detail, this cannot be done a FUNCTION, in Ms. Speak, returns one (and only one) value / variable. In practice, that value can be a UDT, an Array or a CSV string.





MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[CassandraR]

Hi Dan:

Do you need to return the multiple values explicitly from the function (like

MyResult = MyFunction(. . .)

) or would using the ByRef calling feature be adequate?

For example:

    MyResult = MyFunction(intAnotherReturnedValue)

    . . . 

    Private Sub MyFunction(ByRef intARV as Integer) as String

        . . .

        intARV = len(strReturnString) 
        ' MyFunction will "return" intARV since it has 
        ' been declared ByRef.  Thus, intAnotherReturnValue 
        ' will be updated.


        . . .

        MyFunction = strReturnString
    End Sub

Cassie

 

[dlpastel]

What is the best way to return multiple values then?

Thanks,
Dan

 

[dlpastel]

I think that might work.