Create a function which returns severals integers ...

[Rodie]

Hi,

I would to create a function which returns 3 integers. I tried with an array and pointer (I know a function can returns only 1 thing) ... but I didn't succeed ...
Thanks to answer me ...

Rody

 

[EBGreen]

Return a delimited string then split it into an array.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[Zathras]

How are you planning to use this "function"?

It would be much simpler to declare it as a Sub. Then you can have as many arguments (parameters) as you need.

 

[RoyVidar]

In 2000+ versions, functions can return arrays:

[tt]public function myarr() as long()
dim l(2) as long
l(0)=123
l(1)=456
l(2)=789
myarr=l
end function[/tt]

then fetch it with

[tt]dim l() as long
l=myarr
debug.print l(2)[/tt]

Roy-Vidar

 

[PHV]

In the VBA help file take a look at ByRef.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244