Solved

Function resturn array...

Posted on 2000-03-31
5
213 Views
Last Modified: 2010-05-02
How can I set up a function that returns an array?
0
Comment
Question by:mhdhallak
5 Comments
 
LVL 32

Accepted Solution

by:
Erick37 earned 8 total points
ID: 2675244
By passing the array ByRef, you can have a function modify the array passed to it as a parameter:

Option Explicit

Private Sub Command1_Click()
    Dim a(10) As Long
    Call ModifyArray(a)
    Debug.Print a(5)
End Sub

Private Function ModifyArray(a() As Long)
    Dim i As Long
    For i = LBound(a) To UBound(a)
        a(i) = a(i) + 1
    Next
End Function
0
 
LVL 14

Expert Comment

by:wsh2
ID: 2675260
In VB6 arrays can be passed by reference. When you do a ByRef, the subroutine then updates the actual array in the calling procedure. Below is an example.. just copy and paste it into a New Standard.Exe project and run it.. <smile>

<----- Code Begin ----->

Option Explicit

Private Sub Form_Load()

Dim strWork() As String
Dim intWork() As Integer
ReDim intWork(3)
intWork(0) = 1
intWork(1) = 2
intWork(2) = 3
Call MySubroutine(intWork(), strWork())

MsgBox (intWork(0) & " = " & strWork(0) & vbCrLf _
   & intWork(1) & " = " & strWork(1) & vbCrLf _
   & intWork(2) & " = " & strWork(2) & vbCrLf)

End Sub

Private Sub MySubroutine _
(ByRef intNumbers() As Integer, _
ByRef strStrings() As String)

   Dim intIndex As Integer
   ReDim strStrings(UBound(intNumbers))
   For intIndex = 0 To UBound(intNumbers)
     strStrings(intIndex) = intNumbers(intIndex) & " *** "
     intNumbers(intIndex) = intNumbers(intIndex) + 10
   Next intIndex
   
End Sub

<----- Code End ----->
0
 
LVL 14

Expert Comment

by:wsh2
ID: 2675267
You can also do this by using Variants.. an Example follows:

<----- Code Begin ----->

Option Explicit

Private Sub Form_Load()

Dim strWork() As String
Dim intWork() As Integer
Dim varWork As Variant
ReDim intWork(3)
intWork(0) = 1
intWork(1) = 2
intWork(2) = 3
varWork = intWork()
strWork() = MyFunction(varWork)

MsgBox (intWork(0) & " = " & strWork(0) & vbCrLf _
   & intWork(1) & " = " & strWork(1) & vbCrLf _
   & intWork(2) & " = " & strWork(2) & vbCrLf)

End Sub

Private Function MyFunction _
(ByRef varTable As Variant) _
As Variant

   Dim intNumbers() As Integer
   intNumbers() = varTable
   
   Dim strStrings() As String
   ReDim strStrings(UBound(intNumbers))
   
   Dim intIndex As Integer
   For intIndex = 0 To UBound(intNumbers)
     strStrings(intIndex) = intNumbers(intIndex) & " *** "
     intNumbers(intIndex) = intNumbers(intIndex) + 10
   Next intIndex
   
   MyFunction = strStrings()

End Function

<----- Code End ----->
0
 

Author Comment

by:mhdhallak
ID: 2676001
Sorry guys. But Eric was the first one to answer the question and I worked out his answer and it was right.

0
 
LVL 10

Expert Comment

by:caraf_g
ID: 5150881
Erick37 - would you mind sending me an e-mail please, it's quite urgent. deathtospammers@eircom.net
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now