function with dynamic parameters

[Anti-Rich]

hi guys,

i was wondering this morning how i could possibly go about creating a function with dynamic parameters to be passed in.

basically, you know how Excel has the Sum(n1 as number...etc) function? that function takes as many parameters as you want it to, so does anyone know how to replicate a similary functionality in vb.net? i think it would be really handy when performing basic calculations (avg,dividing,multiplication etc)

any ideas would be great!
cheers
adam

 

[Blake81]

Could you pass in an array of numbers? Just a thought.

 

[Anti-Rich]

yeah i could, but rather than have to stuff around creating the array and filling it with members, i would just like to be able to do something like this..

TotalRecieved = Sum(45,20,10)

and have Sum() return the result.

cheers for the feedback. any thoughts?

adam

 

[JohnH]

Mark the last method parameter with the ParamArray keyword. Ex:

Function sum(ByVal ParamArray integers() As Integer) As Integer
    For Each int As Integer In integers
        sum += int
    Next
    Return sum
End Function

[SIZE=2]
MsgBox(sum(1, 2, 3, 4, 5, 6).ToString) '=21
[/SIZE]

 

[Anti-Rich]

excellent!!! thankyou so much johnh, much appreciated. it was exactly what i was looking for...

you know they say... 'you learn something new every day'

cheers mate

regards
adam

 

[Blake81]

That's actually what I was trying to suggest. I would have expanded on my explanation further, but you said you didn't want to worry about filling the array with numbers (which confused me), so I didn't elaborate. Anyway, glad you found your answer.

 

[Anti-Rich]

haha, sorry mate i didnt know about the paramarray keyword, so when you suggested an array of numbers, i thought i would have to create an array, instanciate it, fill it with numbers and then pass it to the function, i didnt realise that you meant in the way of using paramarray,,

hope i didnt offend

have a good one
adam