EXCEL VBA Questions and Answers

What is the method for returning more than one values from a function in VB?

Any of the three methods can be used:
i) Create a class with the properties you require to return and then return the object of the class from the function.
ii) Using ByRef for the values.
iii) Return an array of the values.