Programming Forums > Application Development > Visual Basic

Aenimalius · Feb 10th, 2005, 5:43 PM

Hello everyone,

I'm working on a program that involves adding alot of numbers that are in textbox arrays and popping the sum out into a list box. What I'd like to do is write a function that runs through any array that I give it, adds the numbers and sends back the sum, but I can't figure out how to make the function accept the array.

Is it possible to send a control array to a function? If so, what's the proper syntax to do so? What I'm trying to do is something like this:

(Toggle Plain Text)

Public Function addArray (arrayOfNumbers As ????) As Integer

Dim sum as Integer

For i = 0 to arrayOfNumbers.UBound
     sum = sum + arrayOfNumbers(i)
Next

addArray = sum

End Function

I can't think of a better way to do this, because I'd rather not have 8 or 9 separate pieces of code that do the same thing to different arrays.

Peace.

Rory · Feb 13th, 2005, 5:55 PM

Logically you should be able to do this:
Private Sub MyFunction(ByRef MyArray() as TextBox)

however, VB in its strange way, actually doesn't hold control arrays on forms in the same way as arrays of variables. Similarly the ParamArray keyword won't work. Even if you did get it through, ubound() and lbound() don't work on control arrays, nor does the For Each syntax. The only way I can see of doing it is to pass the control array range to the routine (i.e. the upper and lower bounds).

Feb 10th, 2005, 5:43 PM	#1
Aenimalius Newbie Join Date: Feb 2005 Posts: 3 Rep Power: 0	Passing a control array to a function: Is it possible? Hello everyone, I'm working on a program that involves adding alot of numbers that are in textbox arrays and popping the sum out into a list box. What I'd like to do is write a function that runs through any array that I give it, adds the numbers and sends back the sum, but I can't figure out how to make the function accept the array. Is it possible to send a control array to a function? If so, what's the proper syntax to do so? What I'm trying to do is something like this: (Toggle Plain Text) Public Function addArray (arrayOfNumbers As ????) As Integer Dim sum as Integer For i = 0 to arrayOfNumbers.UBound sum = sum + arrayOfNumbers(i) Next addArray = sum End Function Public Function addArray (arrayOfNumbers As ????) As Integer Dim sum as Integer For i = 0 to arrayOfNumbers.UBound sum = sum + arrayOfNumbers(i) Next addArray = sum End Function I can't think of a better way to do this, because I'd rather not have 8 or 9 separate pieces of code that do the same thing to different arrays. Peace. __________________ Shameless Plug

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 13th, 2005, 5:55 PM	#2
Rory Expert Programmer Join Date: Jan 2005 Location: London Posts: 542 Rep Power: 4	Logically you should be able to do this: Private Sub MyFunction(ByRef MyArray() as TextBox) however, VB in its strange way, actually doesn't hold control arrays on forms in the same way as arrays of variables. Similarly the ParamArray keyword won't work. Even if you did get it through, ubound() and lbound() don't work on control arrays, nor does the For Each syntax. The only way I can see of doing it is to pass the control array range to the routine (i.e. the upper and lower bounds).

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Application Development > Visual Basic

Passing a control array to a function: Is it possible?